SQL Server Performance Tuning and Optimization

SQTH01 Indexing Internals for Developers & DBAs

11/17/2022

8:00am - 9:15am

Level: Intermediate

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

What are the secrets to making your queries run faster? Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions? When you want to understand an application, you look at its core architecture. Underneath the covers, SQL Server is just a C++ application. Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.

You will learn:

  • Gain a rich understanding of when to use indexes
  • Understand when it is appropriate to use heaps and clustered indexes
  • Demonstrate how the internal architecture of indexes lead to a greater understanding of how to performance tune with indexes