Microsoft SQL Server 2008 introduced data compression, a new feature that will compress your objects.  The theory is that it will cut space requirements inside the database, and a smaller database is easier to read off the hard drives.  Your IO time should decrease, and your CPU time shouldn’t be affected that much.

But I never hear about people using it.

So I’m asking you in a short survey: why aren’t you using it?

This entry was posted on Thursday, February 11th, 2010 at 2:47 PM and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.