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 McGraw-Hill Education SAT Subject Test Literature, Fourth Edition by Benjamin Nevarez
Cover of the book Photonic Signals and Systems: An Introduction by Benjamin Nevarez
Cover of the book Home Generator Selection, Installation and Repair by Benjamin Nevarez
Cover of the book English Grammar Drills by Benjamin Nevarez
Cover of the book Living Through Breast Cancer - PB by Benjamin Nevarez
Cover of the book European Child Health Services And Systems: Lessons Without Borders by Benjamin Nevarez
Cover of the book Web Developer's Cookbook by Benjamin Nevarez
Cover of the book Offshore Sailing: 200 Essential Passagemaking Tips by Benjamin Nevarez
Cover of the book Toyota Talent by Benjamin Nevarez
Cover of the book Behavioral Medicine A Guide for Clinical Practice 4/E by Benjamin Nevarez
Cover of the book Cinderella Was a Liar: The Real Reason You Can’t Find (or Keep) a Prince by Benjamin Nevarez
Cover of the book Engineering Hydrology: An Introduction to Processes, Analysis, and Modeling by Benjamin Nevarez
Cover of the book Lean Six Sigma in the Age of Artificial Intelligence: Harnessing the Power of the Fourth Industrial Revolution by Benjamin Nevarez
Cover of the book Clinical Vignettes for the USMLE Step 1: PreTest Self-Assessment and Review Fifth Edition by Benjamin Nevarez
Cover of the book Effective Classroom Practice 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