Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.
Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248
Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)
SQL SERVER – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards
While working together we figured out one of the many issues was the priority boost server configuration. Let us talk about it a bit more in detail.
SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism
One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
SQL SERVER – Power Options, Power Plans and Database Performance
After a careful investigation into their system, we learned that this issue was with Power Options. Let us learn about that in this blog post.