Bob Pusateri asks the important questions:
A few different times I have been asked one or more forms of the following question:
Can datatypes be changed faster with data compression enabled?
I’ve always replied that I’m pretty sure compression will help in this situation, because based on my understanding, it should. But I’ve never had any actual data to back up this belief. Until now. I recently set up a demonstration to test this, and I’m very happy to share the results.
If you want to see the results, you’re going to have to read Bob’s article.