Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
Mastering Index Tuning
Before the Class
Prerequisites
Introductions and Overview (25:29)
Download the Slide Decks
The D.E.A.T.H. Method - Starting with the D.E.
Dedupe and Eliminate (49:27)
Why Index Read & Write Numbers are Wrong (37:03)
Lab 1 Setup: Do the D.E. Steps (6:38)
Lab 1: Brent's Solution (38:32)
The T Step: Tuning Indexes for Specific Queries
Tuning Indexes for Specific Queries (40:19)
Foreign Keys and Check Constraints (18:15)
Lab 2 Setup: Do the T Step (4:32)
Lab 2: Brent's Solution (88:46)
The A Step: Adding Indexes with Clippy and the DMVs
Adding Indexes with Clippy's Recommendations (43:09)
Avoiding Key Lookups and Residual Predicates (21:06)
Lab 3 Setup: Do the A Step (7:11)
Lab 3: Brent's Solution (32:25)
The H Step: Heaps Usually Need Clustered Indexes
Heaps vs Clustered Indexes (37:33)
Tuning Indexes to Avoid Blocking
Blocking: When the 5 & 5 Guideline Isn't Specific Enough (35:16)
Lab 4 Setup: Reducing Blocking with Just Index Changes (4:33)
Lab 4: Brent's Solution (135:07)
Artisanal, Hand-Crafted, Specialized Index Types
Filtered Indexes, Indexed Views, and Computed Columns (28:03)
Lab 5 Setup: Leverage Artisanal Indexes (7:25)
Lab 5: Brent's Solution (36:37)
Recap and Final Lab
Lab 6 Setup and Class Recap (12:52)
Lab 6: Brent Does the D.E.A. (36:47)
Lab 6: Brent Does the D.E.A.T. (30:39)
Bonus: Tips from the Index Sommelier (20:49)
Lab 3 Setup: Do the A Step
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock