Question: Does NOLOCK Really Applies No Lock?
Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server?
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
Question:Â When to Use sort_in_tempdb for Rebuilding Indexes?
How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206
Question: How to Sort a Varchar Column Storing Integers with Order By?
How to Track Autogrowth of Any Database? – Interview Question of the Week #205
Question: How to Track Autogrowth of Any Database?
How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204
Question: How to Create an Empty Table and Fool Optimizer to Believe It Contains Data?
Answer: Before I answer this question, I must acknowledge that I have never heard this question in my 20 years career before and I must ask you back, where do you come up with these kinds of questions.
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question:Â How to Shrink All the Log Files for SQL Server?