SQL Server Performance Tuning and Optimization

SQT12 Everything You Need to Know About SQL Server Indexes


4:15pm - 5:30pm

Level: Introductory to Intermediate

Janis Griffin

Database Performance Evangelist


You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also, with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.

In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will review current SQL Server index structures/options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered and so on will be shown.

This presentation is a must-see for DBAs, developers, application architects and anyone else who's interesting in maintaining high-performance SQL Server applications.

You will learn:

  • All the SQL Server index structures and how they work
  • How to identify which index types to use in specific situations
  • Specific index options such as data compression, new features and best practices on maintaining them