SQLBits 2019

Improving SQL Server Performance with Indexing

Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps

Indexing presents daunting challenges for even the most seasoned professionals, as it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment and improve
the overall performance of your SQL Server applications. In this session you will learn all about the different architectures of indexes, from that how to make the right choices when designing your indexes so that both the database engine and your DBA will love you for it. The session will also cover how to find missing and unused indexes, the cause and how to resolve fragmentation issues as well as how to maintain your indexes after they have been deployed.

After attending this session you will have a much better understanding of how to create the right indexes for your entire environment, not just for that one troublesome query.