Category Table compression

SQL Server 2008 and 2012 table compression the AutoScripting way

This will search all databases on a server for 1. tables of a specific name 2. that are not already compressed and 3. with row counts over 10 million.  The return will be a script that you can look over and decide to run all or pieces of it. I have been dealing with compressed […]