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.

http://blog.niall.com/2011/02/compressing-all-tables-in-a-sql-server-2008-database/

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