Monday, August 1, 2011

Estimate Compression in sql server 2008

Another good feature in 2008.
We can estimate the compression before actually executing it against the tables.
Here is the stored proc:

sp_estimate_data_compression_savings
or
sp_estimate_data_compression_savings <schemaname>,<tablename>,null,null,'page'

null,null are index id and partition numbers. you can give the specific index ids or partition no.s if you know otherwise null will list down for all partitions and all indexes on that table.
<schemaname>,<tablename>,null,null,'row'

No comments:

Post a Comment