The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
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 – 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.
SQL SERVER – Create Index Without Locking Table
Today we will see how we can create an index without a locking table. I really feel depressed when I have to add an index to speed up my queries.
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 – Sample Script to Check Index Fragmentation with RowCount
Let us see a script built for one of my clients of Comprehensive Database Performance Health Check to Check Index Fragmentation with RowCount.