"SQL Server 2008 R2 comes with a lot of features and functionality. Even the Standard version has a long list of capabilities to set DBAs drooling. But then there’s the Enterprise version. A question that comes up, more often than we’d like, is, “Why would I need Enterprise?” If there are so many features available out of the box with SQL Server Standard, why go to the Enterprise version?
If you want to go into it feature-by-feature, the SQL Server website has a comparison site which allows you to look at the features under various headings and see which versions of the product those features are included in.
But if you don’t want to go through the whole list, here are my thoughts on some key ones.
I get asked this a work a good bit, "What version of SQL Server... Why do you want Enterprise?" and so wanted to capture this "human readable" comparison of a few differences.
Related Past Post XRef:
SQL Server 2008 – To buy Enterprise or Standard, that is the question…
SQL Server 2008 Edition Side–by-side Feature Comparison - (aka. What Edition do I need so I can get feature X,Y or Z?)