Learn T-SQL Querying

Table of Contents

1. Anatomy of a Query
2. Understanding Query Processing
3. Mechanics of the Query Optimizer
4. Exploring Query Execution Plans
5. Writing Elegant T-SQL Query
6. Easily Identified T-SQL Anti-Patterns
7. Discovering T-SQL Anti-Patterns in Depth
8. Building Diagnostic Queries Using DMVs and DMFs
9. Building xEvent Profiler Traces
10. Comparative Analysis of Query Plans
11. Tracking Query Performance History with the Query Store
12. Troubleshooting Live Queries
13. Managing Optimizer Changes With the Query Tuning Assistant