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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.

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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}