What a Linked Server Query Sends: Four-Part Names, OPENQUERY and EXEC AT
Which filters and joins reach the remote server in a linked server query? I traced four-part names, OPENQUERY and EXEC AT, and counted the rows.
Trigger Archaeology: Mapping Nested and Recursive Trigger Chains
Map which SQL Server trigger writes to which table before you change a legacy schema, and see what happens at the 32-level nesting limit.
INTERSECT and EXCEPT: Where NULL Finally Behaves
INTERSECT and EXCEPT treat NULL as equal, the one place NULL comparison behaves as expected. Use them for NULL-safe row comparison.
One NULL in a Unique Key, and None Across a Join
A UNIQUE constraint allows one NULL but rejects a second, and an equi-join drops NULL keys. Filtered indexes and NULL-safe joins.
ISNULL vs COALESCE: Not as Interchangeable as They Look
ISNULL and COALESCE differ on result type, truncation, nullability, and how often they evaluate their input. When to use each.