How to insert results of stored procedure into a temporary table without creating the table first? Here is a simple script that shows the steps.
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
Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
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?
What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118
What is the difference between TRUNCATE and DELETE in SQL Server? An interview question that never gets old, with a clear list of the differences.