Mastering Index Tuning

You need to make a SQL Server go faster without changing queries.

Master clustered and nonclustered rowstore indexes in just 3 days of lectures and hands-on labs.

Created by Brent Ozar

Mastering

Course Description

You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. Good news – I’ll teach you how in this 13-hour recorded class.

The class will take you longer to complete because it includes lab assignments that will take you hours to work through, and my students tell me they love doing these labs again and again. They're kinda like SQL Server video games! To follow along, you'll need to build your own SQL Server lab VM.

This is not a live class - if you want to attend live, check out my Live Class Season Pass.

Want to save a bundle? This class is included in my Recorded Class Season Pass: Mastering bundle.

Course Curriculum


  Before the Class
Available in days
days after you enroll
  The D.E.A.T.H. Method - Starting with the D.E.
Available in days
days after you enroll
  The T Step: Tuning Indexes for Specific Queries
Available in days
days after you enroll
  The A Step: Adding Indexes with Clippy and the DMVs
Available in days
days after you enroll
  The H Step: Heaps Usually Need Clustered Indexes
Available in days
days after you enroll
  Tuning Indexes to Avoid Blocking
Available in days
days after you enroll
  Artisanal, Hand-Crafted, Specialized Index Types
Available in days
days after you enroll
  Recap and Final Lab
Available in days
days after you enroll