- SQL Server Execution Engine
Query Lifecycle
- Query Lifecycle
Plan Cache Internals
- Plan Cache Internals
- Query Optimizer & Execution Plan
- 5 Better TSQL Fundamentals
- Better TSQL – Fixing Implicit Conversion
Better TSQL – Sargability
Better TSQL – Rewriting Subqueries
Better TSQL – OVER clause
Better TSQL – Temp Tables vs Table Variables
- Better TSQL – Working with NULLs
Better TSQL – Common Table Expression
Better TSQL – Rewriting Scalar UDFs
- Better TSQL – TVFs Basics
Better TSQL – TVFs with APPLY
Better TSQL – Ranking Functions
- Better TSQL – Dealing with SORTs
Better TSQL – Optimizing OR
Better TSQL – BookmarkLookups SELECT Star
- Better TSQL – Cardinality Fix
Better TSQL – Pivoting
Better TSQL – Stats
- Better TSQL – Aggregations
- Better TSQL – Joins
Better TSQL – NOLOCK
Better TSQL – INEQUALITY
Better TSQL – Complex Expressions
Better TSQL – Fuzzy String Matching
Better TSQL – Things You May Not Know
- Index Tuning Index Basics
Index Tuning Page Splits
Index Tuning Fragmentation
- Index Tuning Dynamic Index Seek
Index Tuning Index Union
Index Tuning Index Intersection
- Index Tuning Fragmentation
Index Tuning Index AND OR
Index Tuning Index Aggregates
Index Tuning Index Joins
- Index Tuning Sargability
Index Tuning MultiColumn Index
Index Tuning Missing and Unused Indexes
Index Tuning Redundant Indexes
- Index Tuning Clustering Key Choices
Stored Procedures Parameters Sniffing
Dynamic SQL
- Waits and Queues Introduction
Waits and Queues PAGEIOLATCH
- Waits and Queues RESOURCE SEMAPHORE
Waits and Queues THREADPOOL
Waits and Queues BUFFERLATCH
Waits and Queues SOS SCHEDULER YIELDS
- Concurrency Part-1
- Concurrency Part-2
- Deadlocks
- Extended Events & Query Store
- Automatic Tuning
Intelligent Query Processing