Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
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 – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes
SQL Server 2016 lets you create additional nonclustered indexes on tables with clustered ColumnStore indexes. 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 Frequently Asked Queries
ColumnStore frequently asked queries on troubleshooting performance: did the optimizer use the ColumnStore index, and if not, why? Trace flags, hints and more.
Interview Question of the Week #040 – Difference Between Unique Index vs Unique Constraint
Compare index vs unique constraint behavior, test filtered uniqueness and NULLs, inspect catalog flags, and remove each object correctly.
Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?
Build an included column index to cover SQL Server queries, compare plans and reads, and distinguish key limits from leaf-level payload.