One command turns an open delta rowgroup into compressed storage. Here is what it leaves behind, and why not to run it after every small load.
SQL SERVER – ShowPlan XML Additions for ColumnStore Indexes
How can you tell if a query used a columnstore index and batch processing? Here are the properties SQL Server adds to the ShowPlan XML for ColumnStore indexes.
SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index
Moving to a Clustered ColumnStore Index can throw Msg 1907: cannot recreate index, as the new definition does not match the constraint. Here is why and the fix.
SQL SERVER – Inserting into ColumnSet with SPARSE Columns
A friend had a table with 1000s of SPARSE columns and asked about inserting into ColumnSet directly. Yes, you can. Here is how it works.
SQL SERVER – Basics ColumnStore FAQ – Part II
Part II of my ColumnStore FAQ: what to check when a ColumnStore index causes a performance regression, starting with whether the optimizer used it.
SQL SERVER – COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression
SQL Server 2014 adds COLUMNSTORE_ARCHIVE data compression for rarely used data. Here is how to use it on older data, at the cost of slower queries.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.