THREADPOOL waits mean tasks waited for a worker thread. Five read-only queries separate real thread starvation from blocking and busy CPUs. The post lists five signs and shows how to raise the cap in small steps.
Max Worker Count: Why Typing 10000 Slowed a Server
Max worker count looks like a speed dial but behaves like a safety limit. A client typed 10000 on an 8 processor server and slowed it, and a reset to 0 fixed it in minutes. Two read-only queries show your value and whether workers run short.
How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236
Question: How to Write in Text File from T-SQL in SQL Server?
The question above was actually asked in an interview and also was not asked in the same word.
Running SQL Server Under a Group Managed Service Account
Set up a group managed service account for SQL Server Engine and Agent, then verify permissions, SPNs, and Kerberos connections.
Listing Non-Default Server Settings From sys.configurations
Inventory non-default server settings with a versioned baseline, compare configured and active values, and keep the review read-only.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Another SQL Server upgrade failure: upgrade step SSIS_hotfix_install.sql hit error 15151 because a user did not exist. Here is how I fixed it.
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
How Does QUOTED_IDENTIFIER Works in SQL Server? I explain it in very simple words, using SELECT “Order By” with the setting OFF and then ON.