To be honest, I’m not a big fan of table partitioning in most scenarios. It’s a data loading & unloading feature thanks to the sliding window scenario, but… most folks just don’t load their data an entire partition at a time. However, when we need to do index maintenance for columnstore indexes, that’s exactly what we…
08 Partitioning Is a Great Partner for Columnstore
To be honest, I’m not a big fan of table partitioning in most scenarios. It’s a data loading & unloading feature thanks to the sliding window scenario, but… most folks just don’t load their data an entire partition at a time. However, when we need to do index maintenance for columnstore indexes, that’s exactly what we…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class
- 0.2 How to Set Up Your Own Lab Server
- 01 How Columnstore Data is Stored
- 02 How Columnstore Data is Deleted, Updated, and Inserted
- 03 How Columnstore Data Is Selected
- 04 How Columnstore Data is Rebuilt
- 05 Clustered Columnstore Quiz: Is Your Table a Good Fit?
- 06 Nonclustered Columnstore Advantages
- 07 A Better Clustered Columnstore Candidate
- 09 Recap