Database Training Days 101: Getting the Right SQL Server Indexes for Peak Performance with MSSQLTips

In this on-demand session, Oracle ACE Director Janis Griffin and Senior Data Architect Eric Blinn reveal how to leverage SQL Server indexes to significantly speed up your queries. Gain expert insights into the power of indexing and discover methodologies to identify which SQL Server indexes will most effectively enhance performance—because indexing every column is not the answer! Janis and Eric will guide you through the use of SQL Server index options, such as filtering and compression, and explore the benefits of different index types, including rowstore and columnstore. Learn when and how to apply these indexing strategies for blazing-fast query execution.

Topics that will be discussed include:

• Understanding the role of indexes in improving query performance
• Methodologies for identifying the most impactful SQL Server indexes
• Exploring SQL Server index options like filtering and compression
• Utilizing rowstore and columnstore indexes for specific use cases

Speakers:

• Janis Griffin, Oracle ACE Director at Quest Software
• Eric Blinn, Senior Data Architect at Squire Patton Boggs