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.
SQL SERVER – Priority Boost and SSMS 18
My client thought SQL Server dropped the Priority Boost setting. It did not. Here is what changed with Priority Boost and SSMS 18 on the Processors page.
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
SQL SERVER – Enabling Older Legacy Cardinality Estimation
A client’s server kept going down on RESOURCE_SEMAPHORE waits, and the quick patch that kept it up was enabling the older legacy cardinality estimation.
SQL SERVER – Cleanup Plan Cache For a Single Database
After tuning a client’s database, a DBA rushed to run DBCC FREEPROCCACHE for the whole server. Here is how to clean up the plan cache for a single database instead.
SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop
SSMS on my laptop could not connect to SQL in Azure Virtual Machine, even though it worked fine on the VM itself. Here is how I fixed the connection.