Mass updating a large set of data with less overhead
Posted on 2013-12-03
I have a large table with about 30 million rows.
There is one column in the table that I have to update to a new value (currently 0, needs to be null).
When I run the normal update table set column = null where column = 0 the query takes for ever, blows up the size of tempdb, etc, etc.
Is there a better way to do this with less overhead?