Completed
The SQLskills Team
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Index Fragmentation - Internals, Analysis, and Solutions
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 The SQLskills Team
- 3 Overview
- 4 Index Structure
- 5 Singleton Lookup
- 6 Range Scan
- 7 Range-Scan: Readahead (1)
- 8 Logical Fragmentation Defined
- 9 Low Buffer Pool Usage
- 10 What is a Page Split?
- 11 Updates During a Page Split
- 12 Page Split Mechanism
- 13 Tracking Page Splits
- 14 What Causes Fragmentation?
- 15 Real-World Examples
- 16 Configuring FILLFACTOR
- 17 sys.dm_db_index_physical stats a
- 18 How to Correct Fragmentation?
- 19 ALTER INDEX ... REBUILD
