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 – Query Specific Wait Statistics and Performance Tuning
After a quick research we figured out the issue was with memory requirement for their query and we used to query specific wait statistics.
SQL SERVER – Performance Impact of Unique Index
In the latest Comprehensive Database Performance Health Check engagement, we had a very interesting situation of Performance Impact of Unique Index.
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 – Upgrade Error: The Server Principal is Not Able to Access the Database “msdb” Under the Current Security Context
The Upgrade Error messages shown in ERRORLOG was “The server principal “SQLAuthority\AuthOwner” is not able to access the database “msdb”
SQL SERVER – SQL Agent Job and Backslash – Strange Behavior
Today’s blog post is about SQL Agent Job and Backslash. I was surprised to see this behavior. Here are the steps to reproduce this behavior.