Sniff
If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding of how they work, and what they’re good for, start here.
For some background information on column store indexes, see these:
- Columnstore indexes: Overview
- Columnstore indexes – Design guidance
- Columnstore indexes – Data loading guidance
- Columnstore indexes – Query performance
- Reorganize and rebuild indexes
For a detailed look at column store from Niko Neugebauer:
For scripts to help you analyze column store indexes:
Joe Obbish’s posts here:
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.