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.
I suggested that the client can experiment with the columnstore indexes and it may help the performance. Comprehensive Database Performance Health Check
Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server?