This is a follow-up blog post of the Winners and Solution – DELETE Qualified Rows From Multiple Tables. Today we will see another efficient solution.
SQL SERVER – Best Value for Max Worker Count
Recently, one of my client who works for the large bank accidentally set incorrect max worker count, which lead to big performance problem.
SQL SERVER – Retrieving N Rows After Ordering Query With OFFSET
Today, we will see the solution to very interesting question received by Martha about Retrieving N Rows After Ordering Query With OFFSET.
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
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.