Alter Table Add Column with a separate Update or Alter Table Add Column with Default takes a long time for large tables. Why it takes long? The update (esp. on tables with many millions of rows) is the issue here. When a default is specified, all rows need to be updated. Updating large amount of rows will 1) […]