Understand the left semi join showplan operator with EXISTS, compare anti and inner joins, and inspect graphical-plan properties.
Interview Question of the Week #037 – What are the Properties of Relational Tables?
Explain the properties of relational tables and connect each rule to SQL Server types, keys, duplicate rows, named columns, and ordering.
Interview Question of the Week #036 – What is the difference between @@DATEFIRST and SET DATEFIRST?
Compare @@DATEFIRST and SET DATEFIRST, test weekday numbering and week boundaries, and make session rules explicit in SQL reports.
SQL SERVER – How to View Objects in mssqlsystemresource System Database?
Facts and myths about the hidden mssqlsystemresource database, database ID 32768, and how you can view objects in mssqlsystemresource if you need to.
Interview Question of the Week #035 – Different Ways to Identify the Open Transactions
Identify open transactions with modern SQL Server DMVs, inspect sleeping owners and recent SQL, and verify a two-window transaction demo.
Interview Question of the Week #034 – What is the Difference Between Distinct and Group By
Answer Interview Question of the Week #034 with runnable DISTINCT and GROUP BY examples, grouped totals, NULL rules, and a COUNT follow-up.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.