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 <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.

No comments:

Post a Comment