A client’s domain-less Always On cluster in Azure could not create a listener: Unable to determine if the computer exists in the domain ‘WORKGROUP’. Here is why.
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
How do you limit the output of Varchar(max) or Nvarchar(max) in a SELECT statement? A simple trick does it, and it works for varbinary(max), text and ntext too.
Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?
Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.
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.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Do queries always respect the Cost Threshold for Parallelism? Not always, and a quick AdventureWorks test with the execution plan shows why.
Plan Cache Size in SQL Server: List Every Cached Plan
Plan cache size shows how much memory each cached query plan takes. This post lists every plan in one database with its size, its text and its execution count. It also explains why the cache entry and the plan itself report different sizes.






