Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Index Tuning
Before the Class
Prerequisites
Introductions and Overview
Download the Slide Decks
The D.E.A.T.H. Method - Starting with the D.E.
Dedupe and Eliminate
Why Index Read & Write Numbers are Wrong
Lab 1 Setup: Do the D.E. Steps
Lab 1: Brent's Solution
The T Step: Tuning Indexes for Specific Queries
Tuning Indexes for Specific Queries
Foreign Keys and Check Constraints
Lab 2 Setup: Do the T Step
Lab 2: Brent's Solution (47:04)
The A Step: Adding Indexes with Clippy and the DMVs
Adding Indexes with Clippy's Recommendations
Avoiding Key Lookups and Residual Predicates
Lab 3 Setup: Do the A Step
Lab 3: Brent's Solution (39:59)
The H Step: Heaps Usually Need Clustered Indexes
Heaps vs Clustered Indexes
Tuning Indexes to Avoid Blocking
Blocking: When the 5 & 5 Guideline Isn't Specific Enough
Lab 4 Setup: Reducing Blocking with Just Index Changes
Lab 4: Brent's Solution (101:07)
Artisanal, Hand-Crafted, Specialized Index Types
Filtered Indexes, Indexed Views, and Computed Columns
Lab 5 Setup: Leverage Artisanal Indexes
Lab 5: Brent's Solution
Recap and Final Lab
Lab 6 Setup and Class Recap
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)
Why Index Read & Write Numbers are Wrong
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock