SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Worth Moving to Enterprise?

I'm starting to see results from other people testing compression and it seems that the data compression can really provide some nice benefits. I did minimal testing since I don't have any great, large databases and I'd have to create a load, which I didn't want to do. However some other MVPs have reported some nice time savings in queries, especially with COUNT().

However this is an Enterprise only feature, and I think part of the reason, along with the Resource Governer and Policy Management being limited to that edition, is that MS wants to try and get people to buy Enterprise. It's a huge revenue increase for them. My guess is that they see this as a way to increase revenue by converting people on the fence between the edtiions. After all, if they put everything in Standard (feature-wise), then why buy Enterprise?

 However I think on a few things they're missing the point. If you added these features to standard, then you are a much, much more attractive platform than Oracle or DB2 at that low price point. Dont' forget that many people have multiple servers and the licensing costs can add up. My vote is that you move "down" a couple features every version from Enterprise to Standard. I haven't seen anything move this time (memory limits went away in 2005 Standard), but I'm hopeful something will change.


The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


No comments.

Leave a Comment

Please register or log in to leave a comment.