Bradley Ball
sqlballs.com
Bradley Ball works for Microsoft on the PSfD team as a Sr. Consultant
SQLBits 2024
Indexing Internals for Developers & DBAs
This is a dive into how indexes work within SQL Server. The goal of this session is for attendees to gain a greater understanding of how Indexes work and how to use them to gain performance.
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.