Why can a stored procedure with a wrong table name be created, but not one with a wrong column name? Deferred Name Resolution explains it.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
SQL SERVER – 2008 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.
REVERSE: Keep Trailing Spaces in String Reversal
REVERSE changes character order while keeping supplied spaces. Use visible boundaries and byte counts to distinguish empty and missing inputs.
SQL SERVER – 2008 – Introduction to SPARSE Columns
A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.
SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
Two convenient SQL Server 2008 features: inline assignment with DECLARE @idx INT = 0, and inline operations like SET @idx += 1. Fewer lines than before.