In SQL Server, you can query the sys.partitions
system catalog view to find out whether or not a partition has been compressed.
In particular, the data_compression
column tells you whether it’s compressed or not. The data_compression_desc
column tells you what type of compression it uses. If it isn’t compressed, it returns NONE
.