Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)
Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.
How to Download the Latest SQL Server Docker Image? – Interview Question of the Week #244
Question: How to Download the Latest SQL Server Docker Image? Answer: The command to download the latest SQL Server Docker Image is here:
Where is Table Variable Created? – Interview Question of the Week #243
Question: Where is Table Variable Created?
Answer: On Hard Disk and NOT in Memory.
I suggest you read the following blogs
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
List all DML triggers created or modified in the last N days in SQL Server, and why modify_date moves when nobody edited the code.