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


