как?

вопрос закрыт.

http://stackoverflow.com/questions/16988326/query-all-table-data-and-index-compression

select  schema_name(o.schema_id) as schemaname,
        object_name(o.object_id) as objectname,
        p.data_compression_desc,
        p.index_id
from sys.partitions p inner join sys.objects o
    on p.object_id = o.object_id
where data_compression <> 2
order by schemaname, objectname