• You said your table is about 20GB. Suppose your data file is 50GB.

    After page compression it is likely your table has a size of about 12GB. So you gain 8GB.

    However, the data file will still be 50GB. If you actually want to gain those 8GB, you'll need to shrink the data file after you compressed the table.

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