Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
SQL SERVER – Compression Delay for Columnstore Index
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.
SQL SERVER – Columnstore Index and Fragementation
One of the questions I had received from a client was about how to find out fragmentation in columnstore index. Let us discuss it today.
SQL SERVER – ColumnStore Index Displaying Actual Number of Rows To Zero
I had a very interesting conversation with their Senior DBA about ColumnStore Index Displaying Actual Number of Rows To Zero.
How to Disable Batch Mode in SQL Server? – Interview Question of the Week #252
My immediate reaction was why would you disable batch mode in SQL Server when it is really is an awesome feature for performance
SQL SERVER – Batch Mode in RowStore – Performance Comparison
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.
SQL SERVER – Simple Example of Batch Mode in RowStore
During Comprehensive Database Performance Health Check, I had a pleasure to demonstrate to customers a Simple Example of Batch Mode in RowStore.