Mastering Query Tuning

When indexes alone aren't enough, and every second counts.

Created by Brent Ozar

Mastering

Course Description

You need to speed up an existing app, and you’re allowed to change both queries & indexes, but you can’t throw hardware at it. Let’s tackle it in 3 days of labs 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 Architect and the Builder: Estimating & Executing Plans
Available in days
days after you enroll
  How SQL Server 2017, 2019, and 2022 Try to Fix Queries Automatically
Available in days
days after you enroll
  Rewrites: Changing Parameters, Results, and Refactoring
Available in days
days after you enroll
  Dynamic SQL
Available in days
days after you enroll
  Advanced Rewrites to Fix Scalability Problems
Available in days
days after you enroll
  Recap and Final Lab
Available in days
days after you enroll