Hello, I have a table with 3.9 billion rows and I need to change the data type from decimal(7,4) to decimal(9,6). I tried several different options. 1. Added a new column on the same table. Updated the new column with the old column value on a batch with 5 million rows. This is taking forever. Initially it is taking 4 mins for 5 million rows and after it completes 1 billion rows, it is taking almost 12 mins....and it keep increasing... 2. Tried altering the column on the same table without adding new column. It is running more than 30 mins and this is filling up the log file. I changed the recovery to "Simple" but still it is filling up the disk with 100GB log file. Any other option available to speed up this ? Thanks in advance.