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
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.
SQL SERVER – Fix Error Msg 10794, Level 16 – The operation ‘CREATE INDEX’ is not supported with memory optimized tables.
A reader tried my ColumnStore on InMemory OLTP example and got Msg 10794: CREATE INDEX is not supported with memory optimized tables. Here is the fix.
SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables – Operational Analytics
SQL Server 2016 lets you add a Clustered ColumnStore index to InMemory OLTP tables for operational analytics. A teaser of my SQLPASS session, with an example.