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 3 days of learning and fun in this recorded class. (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