The most important feature in SQL Server when it comes to getting the required workload performance is probably indexing. But the indexing possibilities you have can be bewildering, and it’s easy to make the wrong choice, leading to wasted resources and maybe even worse performance! In this course, SQL Server: Indexing for Performance, you’ll learn how to correctly choose indexes for your environment. First, you’ll discover how clustered and nonclustered indexes work and how they are used by SQL Server, both of which are crucial when choosing the correct indexes to create. Next you’ll explore the tipping point – when an index can be used or not, the benefits of covering queries, and how to use the INCLUDE option to more effectively cover queries. Finally, you’ll learn how to use filtered indexes and get an introduction to index consolidation for effective server tuning. When you’ve finished this course, you’ll have the skills and knowledge to start adding and changing indexes in your environment for better performance!
Author Name: Kimberly L. Tripp
Author Description:
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her own company SQLskills.com which she now runs with her husband – Paul Randal. Working together Kimberly and Paul enjoy the ability to work on different types of projects – from Immersion Events to consulting to speaking at conferences to writing articles and books. Kimberly has presented lectures and … more

Table of Contents

• Course Overview
  2mins
• Introduction
  11mins
• Row-based vs. Column-based Indexes
  29mins
• Row-based Index Concepts
  35mins
• Choosing the Clustering Key
  21mins
• Clustered Index Internals
  29mins
• Nonclustered Index Internals
  40mins
• Data Access Patterns
  19mins
• Understanding the Tipping Point
  54mins
• Covering Queries
  37mins
• Using INCLUDE to Cover Queries
  29mins
• Understanding Filtered Indexes
  75mins
• Index Consolidation
  43mins