Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
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.