Thursday, July 14, 2011 4:56 AM
rusanu.com
Online non-NULL with values column add in SQL Server 11
Prior to SQL Server 11 when you add a new non-NULLable column with default values to an existing table a size-of data operation occurs: every row in the table is updated to add the default value of the new column. For small tables this is insignificant,
Read More...