Find column definitions in SQL Server with sys.columns, sys.types, and sys.all_columns, including length, nullability, and system objects.
ABS: Widen an Integer Before Taking Its Magnitude
ABS can overflow even when the negative input fits its signed integer type. I widen the input before asking for its magnitude. Casting the output afterward would be too late to protect the calculation.
Protecting an Instance You Cannot Patch Any More
Protect an Instance You Cannot Patch with isolation, least privilege, disabled features, tested backups, and a firm retirement date.
Hierarchyid Subtree: Move With GetReparentedValue
Move a hierarchyid subtree while keeping stable node identifiers. Check the whole branch, repeated requests, missing endpoints and cyclic destinations.
SQL SERVER – Effect of Order of Join In Query
Does the order of join in a query change the result? With AdventureWorks, I show two queries that return the same rows, only in a different order.
SQL SERVER – 2008 – Get Current System Date Time
Several ways to get the current system date time in SQL Server 2008, from GETDATE to the newer functions, with a quick video on the topic.
Pagination With OFFSET and FETCH
OFFSET and FETCH make page-number queries readable, but deep pages scan past prior rows; keyset pagination keeps the next page focused.