If it isn't completely automated it won't work. It needs something along the lines of pestering the creator automatically until they document it or quarantining anything not registered.

I hadn't realised 2012 did this. One small adjustment to your original solution however, add the column first then add the default as a separate operation. This won't change any...

I often look at the request from my managers point of view, then consider convenience to me. If they want me to work late so they can get something ready...

I would expect most instances to reach the MAXMEM setting at some point unless the DB is smaller than the memory available and SQL Server will not always give the...

As Robert mentioned earlier, data on a page isn't necessarily stored in clustering order, it's just on the right page. This means that a table scan without an ORDER BY...