If you a heap (table without indexes) configured for page-level compression, pages receive page-level compression only in the following ways: Data is inserted by using the BULK INSERT syntax Data is inserted using INSERT INTO... WITH (TABLOCK) syntax
Read More...
