Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Mastering Index Tuning

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. 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.

Learning Objectives

Previous Experience

Tech Covered

On-prem, Cloud, performance, tuning, SQL 2019, Azure SQL Database, Managed Instance, DMV, indexing, T-SQL, Database engine, Optimising