SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
SQL SERVER – 3 Different Ways to Set MAXDOP
I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.
What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254
Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
SQL SERVER – Database Scoped Configurations
Recently I was asked a very interesting question by one of my clients on the topic of Database Scoped Configurations. Let us learn today.
SQL SERVER – Enabling Older Legacy Cardinality Estimation
Yesterday, I had a very interesting situation, one of our Comprehensive Database Performance Health Check client immediately called me on Skype with his entire server going continuously stopping due to a very toxic poison wait type of Resource Semaphore. Though, we had a good idea how to fix the wait type the real issue was the server was not staying up long enough to put us a patch in the system. It was extremely frustrating for us and finally, we were able to deploy the patch Enabling Older Legacy Cardinality Estimation.
SQL SERVER – Cleanup Plan Cache For a Single Database
During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database. After making the improvements in the database, we reached to the point where we needed to clear the cache of the server to see how our improvements fairs with the changes which we have made.Â