We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.
SQL SERVER – QUOTENAME Function and Custom Quote Character
The question was really not related to SQL Server Performance Tuning but DBA wanted to know if they can use any custom Quote Character for their string.
SQL SERVER – Number of Rows Read Per Threads in Parallel Operations
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
SQL SERVER – Dynamic SQL and Temporary Tables
Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.
SQL SERVER – Dynamic SQL and Global Temporary Tables
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.