Autoplay
Autocomplete
Previous Lecture
Complete and continue
Fundamentals of Query Tuning
Before the Class
Prerequisites Before the Class
Change Log for This Class
Introductions (1:27)
Download the Slide Decks
How Plans Get Built
How SQL Server Builds Query Plans (51:24)
Good Defaults for New Apps (30:04)
Tools to Improve Cardinality Estimation (92:02)
Execution Plans are Lying Liars (39:27)
Recap
Class Recap (7:31)
Lab: Improving Cardinality Estimation
Lab Setup (2:51)
Fixing usp_RptUsersByName (22:16)
Fixing usp_UsersOutracingMe (12:51)
Fixing usp_RptControversialPosts (20:08)
Fixing usp_YouVsJonSkeet (11:30)
Tools to Improve Cardinality Estimation
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock