Solomon Rutzky (10/5/2012)
now[/i] in SQL Server 2012 you can add a NOT NULL field with a default without locking the table ...
That is a nice little tidbit of information that I had missed in the SQL 2012 documentation. Thanks for pointing that out, that will be helpful.