Autoplay
Autocomplete
Previous Lecture
Complete and continue
Fundamentals of Query Tuning 2026
Before the Class
Prerequisites
Change Log for This Class
Introductions (1:27)
Download the Slides & Demos
How Plans Get Built
How SQL Server Builds Query Plans (64:35)
Good Defaults for New Apps (21:47)
Tools to Improve Cardinality Estimation (66:12)
Execution Plans are Lying Liars (19:18)
Recap
Class Recap (5:43)
Lab: Improving Cardinality Estimation
Lab Setup (4:00)
Fixing usp_RptUsersByName (22:16)
Fixing usp_UsersOutracingMe (19:31)
Fixing usp_RptControversialPosts (20:08)
Fixing usp_YouVsJonSkeet (11:30)
Bonus Modules
Q&A: Compile Memory, CTE Re-Materialization (7:09)
Lab Setup
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock