Mastering Index Tuning

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. I'll teach you the most important advanced lessons in one day.

You'll learn:

  • My D.E.A.T.H. Method to quickly redesign indexes in an existing database
  • How to use sp_BlitzIndex to Deduplicate & Eliminate indexes that need to get out
  • How to use sp_BlitzCache to Add & Tune indexes based on your query workloads
  • When to resort to Hand-crafted indexes like filtered indexes, indexed views, and indexed computed columns

The day will be 25% slides, 75% demos, and 100% useful for both cloud and on-premises installations. I'll be using the Stack Overflow 2013 database, and you're welcome to follow along: just bring a laptop with SQL Server 2016 or newer, or have an Azure SQL DB instance with the Stack Overflow 2013 database already installed.

Speakers

Tuesday 29 September 2020