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…