• Gotcha.

    If it weren't for the disk space, I wouldn't be bothering with this, but...

    Come to find out, part of the reason this wasn't an issue with the previous table is it was page-compressed...

    Kicking around the idea of doing this to the new table, but my concern after reading up on it on MSDN is it will essentially (again) duplicate the table while it compresses it. Which will put me right back here again...

    But, sp_estimate_data_compression_savings estimates it will cut the size down to 1/3 of what it is now, so even if it only halves it, that's still a lot of disk back...

    Thanks again!

    Jason