A friend of mine has a very large table which has a column of type int. Since this table is growing very fast he wanted to alter the table to change the data type from int to bigint.
when he did that, he found that he ran out of disk space on the t-log volume. (600 GB of free space).
why did this happen? shouldn't the type change be a meta data change operation? why was the t-log so heavily used on change of type?
View Complete Post