Nevarez, Benjamin
SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications
- ISBN 13:
- 9781803242620
- author:
- Nevarez, Benjamin
- format:
- Paperback
- publisher:
- Packt Publishing Limited
- language:
- English
- Publication Year:
- 2022
- Pages:
- 446
- Dimensions:
- 23.6 x 18.9 x 3.4 centimetres (0
- Genre:
- Computers, Programming, SQL,
- Condition:
- New
- Availability:
- Item usually sent within 7 working days
Description
Learn to optimize Microsoft SQL Server 2022 queries and applications for high performance. This comprehensive guide covers the inner workings of the query optimizer, intelligent query processing, and new features in SQL Server 2022.
Discover practical techniques for troubleshooting underperforming queries and improving application performance. The book also explores advanced topics such as the Query Store, In-Memory OLTP, and columnstore indexes.
By the end of this book, you'll be able to get the best possible performance from your queries and applications, enabling you to write better queries and provide the query engine with all the information it needs to produce efficient execution plans.
Related Products
Related Products
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
Dam, G
Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
Toth, Kalman
Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
Boggiano, Tracy
Hands-On SQL Server 2019 Analysis Services: Design and query tabular and multi-dimensional models using Microsoft's SQL Server Analysis Services
Hughes, Steven
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server
Pollack, Edward