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: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.