O'Reilly logo
  • Dustin Waybright thinks this is interesting:

Now if the application inserts a row with a new category, the user does not need to add a description immediately but can return later to update the row with the description.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Where description is a NOT NULL DEFAULT column.