SQL Compression – sp_estimate_data_compression_savings stored procedure is available only in the Enterprise, Developer, or Datacenter

I don’t get it.
There’s this feature – called Compression… that is like FANTASTIC for SOME of the times when you absolutely need more space (and can’t get more disk).

What I don’t understand is this- why can’t STANDARD edition at least ESTIMATE_COST_SAVINGS??

I understand that they want to COMPRESSION an enterprise-only feature.. but the ESTIMATE? That’s like saying ‘we can’t tell you how much money you’ll save until you actually buy the product’.

The sp_estimate_data_compression_savings stored procedure is available only in the Enterprise, Developer, or Datacenter editions of SQL Server 2008 and SQL Server 2008 R2.

http://blogs.msdn.com/b/dfurman/archive/2011/02/25/estimating-data-compression-savings-for-entire-database.aspx

WHY OH WHY OH WHY OH WHY is it so hard for them to understand that MAYBE if I could DEMONSTRATE COST SAVINGS- I should be able to create these estimates based on standard edition?  (Isn’t that one of the primary reasons to upgrade to Enterprise Edition?).

I’ve had many many clients buy Enterprise Edition because they think that it magically makes everything run faster.  When _I_ spent $25 grand per processor, I like to make sure I understand the features / requirements before doing so!

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.