Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.
SQL SERVER – Data and Index Compression – Real-World Conversation
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
SQL SERVER – Speed Up Index Rebuild with SORT IN TEMPDB
In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.
SQL SERVER – Two Advantages of Sort in TempDB Options
A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.
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.