Testing a Cumulative Update means restoring real data, replaying key jobs, comparing plans and timings, and signing off before production.
Funny SQL Server Error Messages and What They Really Mean
Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.
RADIANS: Cast Integer Degrees Before Conversion
RADIANS changes degrees into radians, but its input type affects the result. The example contrasts integer and float arguments while keeping the original degree values.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
A foreign key inventory needs both the constraint and its column pairings. I include schema names to identify each table clearly.
GROUPING_ID: Separate Stored NULL Values From ROLLUP Totals
GROUPING_ID helps me distinguish a stored NULL from a subtotal created by ROLLUP. Both can appear in the same column. I keep the grouping bits beside the numbers before adding presentation labels.
SQL SERVER – T-SQL Script to Attach and Detach Database
Detach Database operations remove a database from its instance without deleting its files. I preserve a recoverable backup before moving them.
SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
Add a carriage return with CHAR(13) and a New Line Feed with CHAR(10) in T-SQL. Handy for formatting output, dynamic SQL with GO, and saving user text.