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.Â
SQL SERVER – Number of Rows Read – Execution Plan
Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.
SQL SERVER – DBCC DBREINDEX and MAXDOP Not Possible
Yes, you read it right it is not possible to use DBCC DBREINDEX with MAXDOP hint as far as I know. If there is any method to use it.