Tag Info

New answers tagged

2

(yeah, I added a new column to a multi-billion row table.) Adding a column to a very large table can have implications but there is a clever way of adding column as well. From : Adding NOT NULL Columns as an Online Operation Starting with SQL Server 2012 Enterprise Edition, adding a NOT NULL column with a default value is an online operation when ...


0

In the scenario of adding a column to a VLDB-class table, it may be worth exploring creating a new table with the new structure and moving records from the old table to the new table in small ranges. It'll keep the individual transaction size small so the high-water mark for the Tlog in Simple recovery would be relatively low. You can't avoid ACID ...



Top 50 recent answers are included