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.

Presented by Richard Douglas at SQLBits 2019
MP4 Video Low 400 MB
MP4 Video Med 728 MB
MP4 Video High 1,129 MB
MP4 Video HD 2,130 MB