Columnstore indexes are also created using a parallelized algorithm and somewhat more memory than is used during regular index creation. Microsoft’s proscriptive guidance provides a lot more detail ...
First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work ...