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
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.
Let us see a script built for one of my clients of Comprehensive Database Performance Health Check to Check Index Fragmentation with RowCount.
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.