Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Query Tuning 2026
Before the Class
Introductions (9:08)
Prerequisites
Change Log for This Class
Watch the Live Class
Download the Slides & Demos
How Early & Late Estimates Go Wrong
Explaining How SQL Server Calculates Early Estimates (46:16)
Explaining How SQL Server Calculates Late Estimates (28:03)
How to Write Fast, Safe Dynamic SQL (58:07)
Lab 1 Setup - Improving Estimates (4:00)
Lab 1 - Brent Does It (52:19)
Query Hints and Rewrites
My Favorite Query Hints (49:14)
Using Option Recompile Safely (24:13)
Why You Gotta Rewrite Most User-Defined Functions (18:50)
Lab 2 Setup - Advanced Rewrites (3:26)
How to Write Fast, Safe Dynamic SQL
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock