• There is no data mismatch.

    The only downside is increased CPU usage (the data doesn't (de)compresses itself), but the advantages usually outweigh this.

    The biggest advantage aside from disk savings are the reduced IO and more data that can fit into memory.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP