Autoplay
Autocomplete
Previous Lecture
Complete and continue
Fundamentals of Index Tuning 2026
Before the Class
Introductions (15:08)
Prerequisites
Change Log for This Class
Download the Slides & Demos
The Most Important Index Internals
Setting Good Defaults for New Tables (53:31)
Reading SQL Server's Missing Index Requests (26:49)
How to Visualize Index Contents (30:33)
Designing Indexes for Individual Queries
Designing Indexes for the WHERE Clause (30:03)
Brent Does Your First Hands-On Lab (78:57)
Designing Indexes for ORDER BY (24:58)
Designing Indexes for JOINs (40:46)
Designing and Maintaining Indexes at Scale
Designing Indexes at Scale (55:11)
How to Maintain Databases in 2026 (49:35)
Recapping What You Learned (10:02)
Brent Does the Final Lab (127:21)
Bonus Modules
Where is NVARCHAR(4000) and NVARCHAR(MAX) Stored? (17:53)
Game: Guess the Index (32:29)
Where is NVARCHAR(4000) and NVARCHAR(MAX) Stored?
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock