Microsoft SQL Server 2014 Query Tuning & Optimization

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management, General Computing
Cover of the book Microsoft SQL Server 2014 Query Tuning & Optimization by Benjamin Nevarez, McGraw-Hill Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Benjamin Nevarez ISBN: 9780071829434
Publisher: McGraw-Hill Education Publication: October 10, 2014
Imprint: McGraw-Hill Education Language: English
Author: Benjamin Nevarez
ISBN: 9780071829434
Publisher: McGraw-Hill Education
Publication: October 10, 2014
Imprint: McGraw-Hill Education
Language: English

Optimize Microsoft SQL Server 2014 queries and applications

Microsoft 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 works
  • Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools
  • Work with query operators for data access, joins, aggregations, parallelism, and updates
  • Speed up queries and dramatically improve application performance by creating the right indexes
  • Understand statistics and how to detect and fix cardinality estimation errors
  • Maximize OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored procedures
  • Monitor and promote plan caching and reuse to improve application performance
  • Improve the performance of data warehouse queries using columnstore indexes
  • Handle query processor limitations with hints and other methods
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Optimize Microsoft SQL Server 2014 queries and applications

Microsoft 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.

More books from McGraw-Hill Education

Cover of the book Oracle Database 10g Real Application Clusters Handbook by Benjamin Nevarez
Cover of the book Cunningham and Gilstrap's Operative Obstetrics, Third Edition by Benjamin Nevarez
Cover of the book OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) by Benjamin Nevarez
Cover of the book Fibonacci Trading, Chapter 12 - Using Dynamic Trader Time Projection Reports and Histograms by Benjamin Nevarez
Cover of the book Community and Clinical Pharmacy Services: A step by step approach. by Benjamin Nevarez
Cover of the book Earth Retention Systems Handbook by Benjamin Nevarez
Cover of the book McGraw-Hill's 500 Series 7 Exam Questions to Know by Test Day by Benjamin Nevarez
Cover of the book Brain and Spine Imaging Patterns by Benjamin Nevarez
Cover of the book McGraw-Hill Education 500 Questions to Know by Test Day: Math for the GRE® Test by Benjamin Nevarez
Cover of the book The Ultimate Guide to Choosing a Medical Specialty, Fourth Edition by Benjamin Nevarez
Cover of the book 500 ACT Math Questions to Know by Test Day by Benjamin Nevarez
Cover of the book Teaching Creative Arts & Media 14+ by Benjamin Nevarez
Cover of the book Leading And Coaching Teams To Success: The Secret Life Of Teams by Benjamin Nevarez
Cover of the book Schaum's Outline of Intermediate Algebra, Second Edition by Benjamin Nevarez
Cover of the book How Women Lead: The 8 Essential Strategies Successful Women Know by Benjamin Nevarez
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy