Learn T-SQL Querying

Table of Contents

1. Understanding Query Processing
2. Mechanics of the Query Optimizer
3. Exploring Query Execution Plans
4. Indexing for T-SQL Performance
5. Writing Elegant T-SQL Queries
6. Discovering T-SQL Anti-patterns in Depth
7. Building diagnostic queries using DMVs and DMFs
8. Building XEvent profiler traces
9. Comparative analysis of Query Plans
10. Tracking performance history with Query Store
11. Troubleshooting Live Queries
12. Managing optimizer changes with the Query Tuning Assistant