You need to know workload characteristics when deciding which tables to compress, please could read following article.It provides some guidelines to assist in deciding what to compress.

Data Compression: Strategy, Capacity Planning and Best Practices:http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx