We're using SQL Server 2012 and have page compression turned on for a number of our larger tables. Is there a way we can determine the compression ratio we're getting? We'd like to be able to determine the benefits of compression.
migrated from stackoverflow.com Oct 14 '13 at 0:20
This question came from our site for professional and enthusiast programmers.
It allows you to estimate the gain from compression BEFORE you compress the table, but it's quite accurate.