Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.
SQL SERVER – Activity Monitor and Performance Issue
A small story with a big moral about Activity Monitor and performance issue: a client left the tool open, and the monitor itself slowed the server down.
Finding Every Object That Uses a Column
Find an object that uses a column with dependency metadata and module text search, then check dynamic SQL and application code.
Restoring a Sample Database to New Folders With RESTORE FILELISTONLY
Use RESTORE FILELISTONLY to map backup files to local folders, restore a separate sample copy, and verify its data and log paths.
hierarchyid IsDescendantOf: A Node Includes Itself
hierarchyid IsDescendantOf tests membership in a subtree, including its root. These literal paths keep both compared nodes visible and distinguish self from a strict descendant.
CONCAT: Missing Inputs Produce Present Text
CONCAT builds display text from available inputs. Preserve missing-source flags when output alone cannot prove completeness.
Unpivoting Columns Into Rows With CROSS APPLY and VALUES
Use CROSS APPLY and VALUES for unpivoting columns, retain nulls deliberately, preserve labels, and turn paired fields into aligned rows.