During Comprehensive Database Performance Health Check, I had a pleasure to demonstrate to customers a Simple Example of Batch Mode in RowStore.
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
I was delivering training on SQL Server Performance Tuning, I received a question on nonclustered columnstore index on a temp table.
SQL SERVER – ColumnStore Indexes Without Aggregation
I suggested that the client can experiment with the columnstore indexes and it may help the performance. Comprehensive Database Performance Health Check
Columnstore Rowgroup Health: Finding Small and Open Rowgroups
Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
How do you list all the clustered and nonclustered indexes of your table, including columnstore? Here is the script I use in my performance health checks.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.