1. SQL Server Execution Engine
  2. Query Lifecycle
  3. Plan Cache Internals
  4. Query Optimizer & Execution Plan
  5. Better TSQL – Query Tuning Fundamentals
  6. Better TSQL – Fixing Implicit Conversion
  7. Better TSQL – Sargability
  8. Better TSQL – Rewriting Subqueries
  9. Better TSQL – OVER clause
  10. Better TSQL – Temp Tables vs Table Variables
  11. Better TSQL – Working with NULLs
  12. Better TSQL – Common Table Expression
  13. Better TSQL – Rewriting Scalar UDFs
  14. Better TSQL – TVFs Basics
  15. Better TSQL – TVFs with APPLY
  16. Better TSQL – Ranking Functions
  17. Better TSQL – Dealing with SORTs
  18. Better TSQL – Optimizing OR
  19. Better TSQL – Fixing Bookmark Lookups
  20. Better TSQL – Cardinality Fix
  21. Better TSQL – Pivoting
  22. Better TSQL – Stats
  23. Better TSQL – Aggregations
  24. Better TSQL – Joins
  25. Better TSQL – NOLOCK
  26. Better TSQL – INEQUALITY
  27. Better TSQL – Complex Expressions
  28. Better TSQL – Fuzzy String Matching
  29. Better TSQL – Things you may not know
  30. Index Tuning – Index Basics
  31. Index Tuning – Page Splits
  32. Index Tuning – Fragmentation
  33. Index Tuning – Dynamic Index Seek
  34. Index Tuning – Index Union
  35. Index Tuning – Index Intersection
  36. Index Tuning – Fragmentation Part 2
  37. Index Tuning – Indexing for AND & OR
  38. Index Tuning – Index Aggregates
  39. Index Tuning – Indexing for Joins
  40. Index Tuning – SARGability
  41. Index Tuning – Multi Column Seek
  42. Index Tuning – Multi Column Indexes
  43. Index Tuning – Missing and Unused Indexes
  44. Index Tuning – Redundant Indexes
  45. Index Tuning – Clustering Key Choices
  46. Stored Procedures – Parameter Sniffing
  47. Dynamic SQL
  48. Waits and Queues – Introduction
  49. Waits and Queues – PAGEIOLATCH
  50. Waits and Queues – CXPACKET and PARALLELISM
  51. Waits and Queues – RESOURCE SEMAPHORE
  52. Waits and Queues – THREADPOOL
  53. Waits and Queues – BUFFERLATCH
  54. Waits and Queues – SOS_SCHEDULER_YIELD
  55. Concurrency
  56. Deadlocks
  57. Waits and Queues – EXTENDED Events
  58. Automatic Tuning
  59. Intelligent Query Processing – Adaptive Joins
  60. Intelligent Query Processing – Batch Mode On Row Store
  61. Intelligent Query Processing – Interleaved Execution
  62. Intelligent Query Processing – Memory Grant Feedback
  63. Intelligent Query Processing – Scalar UDF Lining
  64. Intelligent Query Processing – Table Variable Deferred Compilation