I have a table with over 400 million rows in it, and it turns out that one of the columns that was defined as decimal(14,5) needs to be widened to decimal(18,5). The column is not used an any keys or indexes.
What's the fastest way of doing that? When I attempt to change the column definition (right-click the table in SSMS, select Design, update the column definition, then attempt to save), SSMS complains, saying
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created....
View Complete Post