Question: How to Round Up or Round Down Number in SQL Server?
How to Insert Results of Stored Procedure into a Temporary Table? – Interview Question of the Week #124
Question: How to Insert Results of Stored Procedure into a Temporary Table?
How to Find Running SQL Trace? – Interview Question of the Week #123
Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them?
What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan? – Interview Question of the Week #122
Question: What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan?
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Question: How to Find SQL Server Memory Use by Database and Objects?
What is the Initial Size of TempDB? – Interview Question of the Week #120
Question: What is the Initial Size of TempDB? Trust me, this question is way more complicated than you read in one line.
Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119
Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?