Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Columnstore Indexes
Before the Class
Prerequisites Before the Class
Introductions and Overview (6:55)
Download the Slide Deck and Demos
Understanding How SQL Server Stores & Uses Columnstore Data
How Columnstore Data is Stored (33:51)
How Columnstore Data is Deleted, Updated, and Inserted (27:46)
How Columnstore Data is Selected (49:13)
How Columnstore Data is Rebuilt (19:16)
So Is Your Table a Good Fit for Clustered Columnstore?
Recap of What We've Learned So Far (8:10)
Nonclustered Columnstore Indexes
Nonclustered Columnstore: When Clustered Columnstore Doesn't Make Sense (11:34)
Big Data: Why Partitioning Works So Well with Columnstore
A Bigger, Better Clustered Columnstore Candidate Table (20:17)
Why Partitioning is a Great Partner for Columnstore (45:27)
Recap
Recap (10:14)
Nonclustered Columnstore: When Clustered Columnstore Doesn't Make Sense
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock