Hot answers tagged

3

This is a good reference and explanation for row v page (no pun intended) compression: http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-sql-server-data-compression/ In short though, page compression encompasses the algorithms contained with row level compression and then also covers Prefix compression and Dictionary compression. Prefix and ...


1

In order to make a decision for bunch of tables you can run procedure "sp_estimate_data_compression_savings": exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,ROW; exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,PAGE; That will help you determine savings for each particular table. From my experience PAGE ...



Only top voted, non community-wiki answers of a minimum length are eligible