Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Index Tuning
Before the Class
Prerequisites
Introductions and Overview (24:13)
Download the Slide Decks
The D.E.A.T.H. Method - Starting with the D.E.
Dedupe and Eliminate (47:39)
Why Index Read & Write Numbers are Wrong (27:22)
Lab 1 Setup: Do the D.E. Steps (6:09)
Lab 1: Brent's Solution (33:46)
The T Step: Tuning Indexes for Specific Queries
Tuning Indexes for Specific Queries (36:14)
Foreign Keys and Check Constraints (19:34)
Lab 2 Setup: Do the T Step (5:11)
Lab 2: Brent's Solution (104:15)
The A Step: Adding Indexes with Clippy and the DMVs
Adding Indexes with Clippy's Recommendations (44:01)
Avoiding Key Lookups and Residual Predicates (23:11)
Lab 3 Setup: Do the A Step (4:04)
Lab 3: Brent's Solution (39:59)
The H Step: Heaps Usually Need Clustered Indexes
Heaps vs Clustered Indexes (38:36)
Tuning Indexes to Avoid Blocking
Blocking: When the 5 & 5 Guideline Isn't Specific Enough (27:14)
Lab 4 Setup: Reducing Blocking with Just Index Changes (2:05)
Lab 4: Brent's Solution (128:39)
Artisanal, Hand-Crafted, Specialized Index Types
Filtered Indexes, Indexed Views, and Computed Columns (47:16)
Lab 5 Setup: Leverage Artisanal Indexes (3:56)
Lab 5: Brent's Solution (36:16)
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