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?
How to Start Database in a Single User Mode? – Interview Question of the Week #202
Question:Â How to Start Database in a Single User Mode?Â