Thank this author by sharing:
By Jay Rajgor,
Although, SQL Server 2008 provides new Feature for DATA COMPRESSION -- There are not many Stored Proc. provided by MS to handle page compression at DB level (Partitioned /non-partitioned). Following PROC, can be handy to compress all objects in a Database with control of what partitions gets compressed.
Undo Data Compression/Partition Row Level Locking
SQL Server 2008 brings with is a new set of features involving compression. At first I was assuming...
Testing and analysis of new backup compression and table/index compression features of SQL Server 20...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.