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 – Find Count of Table Used in Query From Cache
we had an interesting situation where we wanted to Find the Count of Table Used in Query From Cache. Let us see how we can do that in today’s blog post.Â
SQL SERVER – Disable Rowgoal Optimizer
In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?
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 – Fill Factor – Instance Level or Index Level
One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.