My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins.
SQL SERVER – Enable Adaptive Join
Let us learn how we can enable the adaptive join feature in SQL Server. I often discuss this during Comprehensive Database Performance Health Check.
SQL SERVER – Flush Data from Memory to Disk
One of my clients asked me how to Flush Data from Memory to Disk during a recent consulting engagement Comprehensive Database Performance Health Check.
SQL SERVER – List Expensive Queries – Updated March 2021
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.
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 – 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.