What is the difference between NORECOVERY and RECOVERY when restoring a database, and what is the right restore sequence? A plain explanation of both.
Decimal Multiplication: Precision Can Reduce the Result Scale
Decimal Multiplication derives a result type from its operand types, and the precision limit can reduce the scale. I inspect three small products. A small numeric value does not necessarily imply a narrowly declared arithmetic result.
Columns With No Statistics: Read Each Warning
A columns-with-no-statistics warning needs a column-by-column investigation. Compare warning lists before and after targeted statistics creation, and check the actual query behavior before deciding that a missing statistic caused poor performance.
CAST Without a Length: The Default Can Truncate Text
CAST Without a Length can silently choose a target width that is too short for the source text. I compare omitted and explicit lengths. The same conversion syntax can look harmless while losing the end of a string.
CROSS APPLY VALUES: Unpivot Fixed Columns and Preserve NULLs
CROSS APPLY VALUES can turn a fixed set of columns into rows without dropping their NULL values. I make any missing-value filter explicit. That keeps the reshaping step separate from the decision to exclude data.
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
What is the difference between Line Feed (\n) and Carriage Return (\r)? Why Windows, Mac and Unix read a new line differently, and what it means in T-SQL.
SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
An introduction to Policy-Based Management in SQL Server 2008: facets, conditions, policies, and how to create, evaluate and fix non-complying policies.