Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.
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.
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.
A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.
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.