How do you do a case sensitive search in SQL Server? Use COLLATE Latin1_General_CS_AS in the query, or change the column collation to make it permanent.
Interview Question of the Week #044 – What is the difference of performance between SELECT and SET?
What is the performance difference between SELECT and SET? SELECT can assign many variables at once, but how each handles rows matters more.
Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN
Compare EXCEPT operator vs. NOT IN using NULL and duplicate examples, add NOT EXISTS, and inspect actual SQL Server anti-join plans.
Interview Question of the Week #042 – How Does SPACE Function Works in SQL Server?
Explain how the SPACE function works, inspect LEN and DATALENGTH, handle negative input and NULL, and understand trailing-space equality.
Interview Question of the Week #041 – What is a Merge Join?
Explain what is a merge join in the SQL Server engine, test ordered inputs and duplicates, and compare merge, hash, and nested loops plans.
Interview Question of the Week #040 – Difference Between Unique Index vs Unique Constraint
Compare index vs unique constraint behavior, test filtered uniqueness and NULLs, inspect catalog flags, and remove each object correctly.
Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?
Build an included column index to cover SQL Server queries, compare plans and reads, and distinguish key limits from leaf-level payload.