compress all tables and indexes on SQL 2008 Enterprise

To date I have found on SQL Server 2008 R2 with a reasonable external disk array and reasonable number of processor cores that disk compression offers a significant improvemnt in terms of performance as well as the number of records you can store in any given amount of disk space. Below is a quick script I knocked up to Page compress all tables and indexes in a database.

This entry was posted in SQL Server and tagged . Bookmark the permalink.