After creating your database just apply these
EXEC sp_estimate_data_compression_savings ‘dbo’,
‘Table_Name’, NULL, NULL, ‘PAGE’
AND
ALTER TABLE Datamart_DB
REBUILD WITH (DATA_COMPRESSION = PAGE)
After creating your database just apply these
EXEC sp_estimate_data_compression_savings ‘dbo’,
‘Table_Name’, NULL, NULL, ‘PAGE’
AND
ALTER TABLE Datamart_DB
REBUILD WITH (DATA_COMPRESSION = PAGE)