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 existing rows in the table and so it is fast, then update in batches if required.