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 – Wait Stats Collection Scripts : Updated March 2021
I have updated my SQL Wait Stats Collection Script for my clients. In today’s blog post we will be looking at the newly updated SQL Wait Statistics Script.
SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL
RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.
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 – Finding Fragmentation in Forwarded Records
I was asked by my client if there any way to know if there is any way of Finding Fragmentation in Forwarded Records. Let us learn in today’s blog post.
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.