Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know

Abstract

You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy.

After attending this demo rich session you will be able to

• Explain the differences between SQL Servers 9 "index" types
• Identify the layout of SQL Server data on disk
• Decide which index types are the right ones to use for a given query
• Assess the impact of the Key on access speed

Prerequisites

To get the most out of this talk, you should feel comfortable writing multi-table queries. You also should know the basic indexing terminology.

Materials

Slides

Feedback

Feedback Form for Attendees