SQL Server 2008 Compression feature and INSERTS

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 A table is rebuilt by executing the ALTER TABLE….REBUILD statement with the PAGE compression option When you…

1