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.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.