Deep dive into SQL Server query optimizer internals for effective query tuning
Practical optimization techniques for troubleshooting and improving query performance
Coverage of new SQL Server 2022 features like Query Store and In-Memory OLTP
Step-by-step guidance on using indexes, cardinality estimation, and hints
Hands-on examples for monitoring, caching, and promoting plan reuse
Get well-versed with ready-to-use techniques for creating high-performance queries and applications
Key Features
Speed up queries and dramatically improve application performance by both understanding query engine internals and practical query optimization
Understand how the query optimizer works
Learn about intelligent query processing