Someone said columnstore indexes run only in batch mode. I stopped to disagree. Here is what I showed about columnstore batch mode vs row mode.
SQL SERVER – Finding Size of a Columnstore Index Using DMVs
This script uses sys.indexes and sys.dm_db_partition_stats to list the size of a columnstore index on disk, along with its table name.
A Repeatable Workload: Testing a Tuning Change Fairly
One quick run can fool you. Here is a small, fixed test you can rerun before and after any index.
SQL SERVER – Renaming Index – Index Naming Conventions
Tables got renamed to a new standard, but what about the indexes? Tell me which index naming conventions you follow when renaming an index.
Changing an Index In Place With CREATE INDEX and DROP_EXISTING
Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.