Procedure used for applying Database Compression

A very handy SQL Server 2008 data compression procedure was posted by my collegue Juergen Thomas with his extensive background in SAP.  He propped up an excellent blog post about data compression at: Procedure used for applying Database Compression to Microsoft SAP ERP system.

What is interesting here is that he had created a procedure that would go through and compress all of the tables and indexes within your database using various options (online, batch, schemas, etc.) so that way you didn’t have to write your own statements to individually go through each table and compress them yourselves. 

It’s a very handy procedure (the attachement is at the bottom of his post) that you can use for all of your own systems (i.e. not just SAP but also non-SAP systems) to quickly go through and compress all of your tables and indexes.

Thanks to Juergen for this quick and awesome procedure!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s