Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
SQL Server Indexing for Developers
Getting started
Who is this course for? (1:18)
Who is Greg? (1:08)
Why focus on indexing? (1:56)
What will I learn in this course? (1:42)
Configuring your lab environment (12:19)
Core indexing concepts
Why index at all? (2:30)
Most common index types (1:11)
Specialty index types (3:10)
Introduction to PopkornKraze (3:36)
Table and index structures
Files, extents, and pages (1:37)
What is a heap? (2:59)
Tables as heaps (7:11)
What is a clustered index? (4:58)
Tables with clustered indexes (7:33)
Non-clustered indexes (2:31)
Non-clustered indexes over heaps (6:23)
Non-clustered indexes over clustered indexes (5:19)
Lab 1: Table and index structures
Lab 1 Answers
Quiz 1: Table and index structures
Indexing for constraints
Primary keys (1:52)
Default structure for primary keys (2:24)
Unique constraints (1:25)
Foreign keys (4:29)
Lab 2: Indexing for constraints
Lab 2 Answers
Quiz 2: Indexing for constraints
Covering queries with indexes
Lookups (2:32)
Cost of lookups (6:11)
Covering indexes (1:01)
Included columns (6:38)
Notes on included columns
Clustering key as an included column (2:19)
Indexes for queries that join multiple tables
Lab 3: Covering queries with indexes
Lab 3 Answers
Quiz 3: Covering queries with indexes
Clustering keys and data types
Choosing a clustering key (2:32)
Integers and big integers (2:19)
Identity columns (6:07)
Sequences (4:51)
String values (2:37)
Bits (boolean values) (2:28)
Filtered indexes (6:01)
Unique identifiers (GUIDs) (9:00)
Lab 4: Clustering keys and data types
Lab 4 Answers
Quiz 4: Clustering keys and data types
Index characteristics
Index selectivity and density (1:14)
Column order within an index (2:23)
Ascending vs descending (1:38)
Index uniqueness (1:58)
Index depth (2:51)
Statistics (4:29)
Index fragmentation (3:29)
Heap fragmentation (2:14)
FILLFACTOR and PAD_INDEX (3:53)
Lab 5: Index characteristics
Lab 5 Answers
Quiz 5: Index characteristics
Indexing design strategies
Reasonable starting point (3:41)
Tracing and analyzing workloads (3:57)
Missing indexes - DTA (2:31)
Missing indexes - DMVs (7:29)
Indexed views (5:27)
Lab 6: Index design strategies
Lab 6 Answers
Quiz 6: Index design strategies
Rationalizing indexes
Unused indexes (4:31)
Duplicate and subset indexes (1:42)
Merge covering indexes (2:31)
Lab 7: Rationalizing indexes
Lab 7 Answers
Quiz 7: Rationalizing indexes
Next steps
Summary and further steps (0:59)
Non-clustered indexes over clustered indexes
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock