data in SQL Server can be compressed at the page level. This means that when you compress a table, it actually does it a page at a time. I'd advise you to tread lightly with data compression.

If you have a lot of repeating data, then table-level page compression will be your best friend. The order of your data matters also. Because SQL Server compresses at the page level, repeating ...

The best SQL Server release to date, it sports more nice new features than you can count, and the improvements extend to both performance and manageability. Whether you manage an OLTP environment ...

The good news is, once compression is enabled on a table, all the intelligence is handled by SQL Server, your application code does not have to change and you may see immediate space savings with ...

Many of the features that currently exist in SQL Server 2005 are still there, but enhanced to make administration even that much easier. * Table Partitioning & Locking: Performance improvements ...

data in SQL Server can be compressed at the page level. This means that when you compress a table, it actually does it a page at a time. I'd advise you to tread lightly with data compression.