Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

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)

Scripts for Full DB Compression at partition level

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.


key features:

  • Page/Row Compresses all objects in a given Database
  • If DB is partitioned and you wan to compress only RANGE of PARTITIONS - you can specifiy partition range
  • To compress specifc partition, just pass in Same partition number as Start and End partition
  • Also compresses non partitioned tables/indexes.

Total article views: 1087 | Views in the last 30 days: 1
Related Articles

Undo Data Compression/Partition Row Level Locking

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...


SQL Server 2008 Compression

Testing and analysis of new backup compression and table/index compression features of SQL Server 20...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

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.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones