Thalia.de

Microsoft SQL Server 2014 Query Tuning & Optimization


Optimize Microsoft SQL Server 2014 queries and applicationsMicrosoft SQL Server 2014 Query Tuning & Optimization is filled with ready-to-use techniques for creating high-performance queries and applications. The book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You'll also get tips for troubleshooting underperforming queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, is fully covered in this practical guide. Understand how the query optimizer worksTroubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other toolsWork with query operators for data access, joins, aggregations, parallelism, and updatesSpeed up queries and dramatically improve application performance by creating the right indexesUnderstand statistics and how to detect and fix cardinality estimation errorsMaximize OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored proceduresMonitor and promote plan caching and reuse to improve application performanceImprove the performance of data warehouse queries using columnstore indexesHandle query processor limitations with hints and other methods
Portrait

Benjamin Nevarez is a Microsoft SQL Server MVP and independent consultant with more than 20 years of experience in relational databases. He specializes in SQL Server query tuning and optimization. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections, and SQLBits.
… weiterlesen
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Beschreibung

Produktdetails


Einband Taschenbuch
Seitenzahl 416
Erscheinungsdatum 01.12.2014
Sprache Englisch
ISBN 978-0-07-182942-7
Verlag McGraw-Hill Education Ltd
Maße (L/B/H) 231/184/25 mm
Gewicht 629
Buch (Taschenbuch, Englisch)
42,99
inkl. gesetzl. MwSt.
Sofort lieferbar
Versandkostenfrei
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Andere Kunden interessierten sich auch für

  • 43564382
    Milk and Honey
    von Rupi Kaur
    (2)
    Buch (Taschenbuch)
    12,99 bisher 14,99
  • 15365119
    Thirteen Reasons Why
    von Jay Asher
    (13)
    Buch (Taschenbuch)
    8,29
  • 47566547
    Good Night Stories for Rebel Girls
    von Francesca Cavallo
    Buch (gebundene Ausgabe)
    16,99 bisher 21,20
  • 54619015
    Thirteen Reasons Why. TV Tie-In
    von Jay Asher
    Buch (Taschenbuch)
    7,79 bisher 8,99
  • 17283460
    Thirteen Reasons Why
    von Jay Asher
    (13)
    Buch (Taschenbuch)
    8,99
  • 34910866
    The Life List
    von Lori Nelson Spielman
    (5)
    Buch (Taschenbuch)
    6,99 bisher 9,70
  • 1719784
    The Giver
    von Lois Lowry
    (1)
    Schulbuch (Taschenbuch)
    9,99
  • 54193482
    Thirteen Reasons Why
    von Jay Asher
    Buch (Taschenbuch)
    8,99
  • 23361882
    Thirteen Reasons Why
    von Jay Asher
    Schulbuch (Taschenbuch)
    9,60
  • 17345365
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - Looking for Alaska
    von John Green
    (22)
    Schulbuch (Taschenbuch)
    10,25
  • 38930428
    We Were Liars
    von E. Lockhart
    (11)
    Buch (Taschenbuch)
    7,99 bisher 10,49
  • 46576306
    The Hate U Give
    von Angie Thomas
    (1)
    Buch (gebundene Ausgabe)
    11,49 bisher 13,49
  • 4593954
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - The Perks of Being a Wallflower
    von Stephen Chbosky
    (25)
    Schulbuch (Taschenbuch)
    10,25
  • 40670892
    Perfect
    von Cecelia Ahern
    Buch (Taschenbuch)
    8,69 bisher 9,99
  • 45243079
    Fantastic Beasts and Where to Find Them. The Original Screenplay
    von Joanne K. Rowling
    (17)
    Buch (gebundene Ausgabe)
    14,95 bisher 21,99
  • 14751780
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - The Curious Incident of the Dog in the Night-Time
    von Mark Haddon
    (11)
    Schulbuch (Taschenbuch)
    10,25
  • 46297446
    Court of Wings and Ruin
    von Sarah J. Maas
    Buch (gebundene Ausgabe)
    17,99
  • 43831163
    A Court of Thorns and Roses 3
    von Sarah J. Maas
    Buch (Taschenbuch)
    8,09
  • 45795728
    Norse Mythology
    von Neil Gaiman
    (1)
    Buch (gebundene Ausgabe)
    11,59 bisher 12,89
  • 4570744
    The Curious Incident of the Dog in the Night-Time
    von Mark Haddon
    (11)
    Buch (Taschenbuch)
    8,99

Kundenbewertungen


Es wurden noch keine Bewertungen geschrieben.