SQL Server Performance: Indexing Basics

—Introduction 1m 49s
—Primary Key 1m 12s
—Demo: Primary Key 3m 42s
—Over Indexing 0m 53s
—Demo: Over Indexing 2m 11s
—Duplicate Index 0m 46s
—Demo: Duplicate Index 2m 40s
—Clustered Index 1m 35s
—Demo: Clustered Index 2m 32s
—Unique Index 0m 37s
—Demo: Unique Index 4m 14s
—Included Columns 1m 5s
—Demo: Included Columns 4m 16s
—Filtered Index 0m 48s
—Demo: Filtered Index 4m 4s
—Disabled Index 0m 45s
—Demo: Disabled Index 3m 39s
—Summary 0m 37s

—Introduction 1m 54s
—Demo: Index Maintenance 6m 32s
—Defragmentation 1m 16s
—Demo: Defragmentation 4m 39s
—Additional Information 0m 58s
—Summary 1m 14s

—Introduction 0m 55s
—Concepts 2m 4s
—Demo 3m 23s
—Additional Information 0m 51s
—Summary 0m 53s

—Index and Page Types 2m 0s
—Index and Non Deterministic Columns 1m 43s
—Index and SET Values 1m 23s
—Importance of Clustered Index 1m 36s
—Effect of Compression and Fillfactor 2m 52s
—Index and Functions 3m 25s
—Dynamic Management Views (DMV) - Fillfactor 1m 30s
—Table Scan, Index Scan and Index Seek 2m 56s
—Index and Order of Columns 7m 31s

—Final Checklist 7m 29s