Today we will talk about the Compression Delay for Columnstore Index which I got the first-hand experience with my client of Performance Health Check.
I had a very interesting conversation with their Senior DBA about ColumnStore Index Displaying Actual Number of Rows To Zero.
My immediate reaction was why would you disable batch mode in SQL Server when it is really is an awesome feature for performance
Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.
During Comprehensive Database Performance Health Check, I had a pleasure to demonstrate to customers a Simple Example of Batch Mode in RowStore.
I was delivering training on SQL Server Performance Tuning, I received a question on nonclustered columnstore index on a temp table.