ISBN 9789339222314,Microsoft Sql Server 2014: Query Tuning & Optimization

Microsoft Sql Server 2014: Query Tuning & Optimization



Tata McGraw - Hill Education

Publication Year 2015

ISBN 9789339222314

ISBN-10 9339222318


Number of Pages 416 Pages
Language (English)

SQL Server / MS SQL

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.

Table Of Contents:
1. Tuning Architecture 2. Troubleshooting Queries 3. Query Optimizer 4. Query Operators 5. Indexes 6. Statistics 7. In-Memory Oltp (Hekaton) 8. Parallelism 9. Plan Cache 10. Data Warehouses 11. Query Processor Limitations