Question: How I Know If I am DBOWNER or Not in SQL Server?
How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221
Question: How to check the ANSI Compatibility of SQL Server queries?
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
Question: How to Compile Queries and Not Execute them?
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
Question: How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement?
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
Question: How Does QUOTED_IDENTIFIER Works in SQL Server?Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Question: Do Queries Always Respect Cost Threshold of Parallelism?