Use UPDATE with a JOIN safely, reject duplicate source keys, compare subquery and MERGE behavior, and verify the affected rows.
STRING_SPLIT and Its Ordinal Column
STRING_SPLIT and its ordinal column preserve token positions when you request the third argument and sort by ordinal in SQL Server.
smalldatetime: Minute Rounding Can Change the Day
smalldatetime does more than hide seconds. These explicit conversions show minute rounding and a midnight carry, with complete original timestamps retained.
ISO Week Numbers: Find the Matching ISO Week Year
ISO week numbers can belong to a different year from the calendar date. A Thursday-based calculation keeps the ISO year and week together across December and January.
CDC Capture Lag: Read sys.dm_cdc_log_scan_sessions
CDC capture lag measures work committed at the source that the capture process has not yet exposed. Compare known markers, scan sessions and captured LSNs, and distinguish capture progress from a downstream consumer reading the changes.
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines
sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.
SQL SERVER – Location of Resource Database in SQL Server Editions
The Resource database contains SQL Server system objects. I use version-specific guidance to locate its files and plan recovery.