SentryOne Team Blog (blogs.sentryone.com)

Tag : ddl

T-SQL Tuesday #080 : CREATE OR REPLACE

Aaron Bertrand (@AaronBertrand) submits a wish list item for the 80th T-SQL Tuesday : CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.

A "drop column" fix you'll want for SQL Server 2012 / 2014

Aaron Bertrand (@AaronBertrand) cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.