SQL Server Query Tuning and Optimization

Table of Contents

1. An Introduction to Query Tuning and Optimization
2. Troubleshooting Queries
3. The Query Optimizer
4. The Execution Engine
5. Working with Indexes
6. Understanding Statistics
7. In-Memory OLTP
8. Understanding Plan Caching
9. The Query Store
10. Intelligent Query Processing
11. An Introduction to Data Warehouses
12. Understanding Query Hints