This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.