During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – Enable or Disable Resource Governor
Resource governor which was accidentally enabled by one of their database administrators. Let us learn how to disable resource governor in this blog post.Â
SQL SERVER – Swap Column Values In Table
Here is a question asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.
SQL SERVER – Microsoft Official Support End Dates for Different Versions
Earlier this week, Microsoft SQL Server 2008 and 2008 R2 support ended. I am mentioning Microsoft’s Official Support End Dates for different versions.
SQL SERVER – What is Wait Type Parallel Backup Queue?
Only official documentation which I could find was about wait statistics related to Parallel Backup Queue is very little available online.
SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On
We will learn how the full backup size can be different on the primary and secondary replica for an availability database in Always On availability group.
SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure
First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.