Question: What is Clean Buffer in DBCC DROPCLEANBUFFERS?
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
Question: How to Extract Alphanumeric Only From A String?
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
Question: How to Find Table Cardinality from the Execution Plan?
What is Consolidation of Index? – Interview Question of the Week #212
Question: What is Consolidation of Index?
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Question: Does Parallel Threads Process Equal Rows?
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
Question: What is Trusted Constraint in SQL Server?
Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209
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.