List Compressed Tables on SQL SERVER

Here is simple query to list all compressed tables on SQL SERVER:

select distinct t.name AS CompressedTables

from sys.partitions p

inner join sys.tables t

on p.object_id = t.object_id

where p.data_compression > 0

Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06