You'd want to make sure PAGE compression was actually appropriate for each specific table first. In certain cases, page compression doesn't do enough good to make it worth SQL's effort to test the compression on each page.
You use a system proc to do that:
EXEC sys.sp_estimate_data_compression_savings 'schema_name', 'table_name', NULL /*or specific index number*/, NULL, 'PAGE' /*or 'ROW' or 'NONE'(to check it w/o compression*/
Sometimes ROW compression is better for a given table.
SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."