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...
Data compression is often misunderstood to cost CPU in exchange for smaller size on disk. Somewhat ...