This is something I planned to start a while ago and never found the time to do it properly. The idea behind this series of posts is to highlight what are all those benefits which are only available in the Enterprise Edition. Not only the ones well renown and advertised by our marketing folks, but also those subtle tough extremely powerful and beneficial hidden jewels which are typically just ignored because they are difficult to explain.
It is so common to hear SQL Server users saying: "Why would I want to choose the Enterprise Edition of SQL Server if the Standard edition also supports failover clustering?"
To be honest, that simplistic assertion knocks me out. 😛
First of all, it isn't true that failover clustering support was the only difference between Standard and Enterprise editions in previous versions. There was much more than that. But we won't touch the SQL Server 2000 topic eleven years after its release. That wouldn't be of too much value for you. Instead, we prefer to focus in SQL Server 2008 R2.
In the current release there is so much extra value in the Enterprise Edition, that we prefer to believe that those users who agree with the statement above, is just because they haven't really been explained what all that value is, which form it adopts within the product, and how they can actually benefit from it.
For that reason, I feel it's our obligation to show you all these benefits, using simple and clear examples or pointing to already existing ones that typically forget to mention the feature being exposed requires the Enterprise Edition to benefit from it. The aim is helping you to take better decisions when it comes to choosing the most appropriate edition of SQL Server to satisfy your business requirements.
So, keep tuned and don't miss any of those deliveries if you want to make the best decisions.
Every post in this series will be published on Fridays and the most current list will be kept updated and linked from this post.
- Soft-NUMA Configuration (Fri Sep 23rd, 2011)
- Large Memory Pages (Fri Sep 30th, 2011)
- Resource Governor (Fri Oct 7th, 2011)
- Fuzzy Grouping Transformation (Fri Oct 14th, 2011)
- SQL Server Audit (Fri Oct 21st, 2011)
- Database Tuning Advisor support for recommending Indexed Views (Fri Oct 28, 2011)
- Online Restore (Fri Nov 4th, 2011)
- Backup Mirroring (Fri Nov 11th, 2011)
- Up to 2TB of memory (Fri Nov 18th, 2011)
- Fast Recovery (Fri Nov 25th, 2011)
- Running DBCC CHECK* in parallel (Fri Dec 2nd, 2011)
- Log manager uses locked pages in memory (Fri Dec 9th, 2011)
- Concurrent, Shared, or Merry-go-round Scans (Fri Dec 16th, 2011)
- Partitioned Tables and Indexes (Fri Dec 23rd, 2011)
- Online Index Operations (Fri Dec 30th, 2011)
- Updatable Distributed Partitioned Views (Fri Jan 7th, 2012)
- Honor Lazy Schema Validation option in a Linked Server (Fri Jan 14th, 2012)
- View Substitution Implicitly Allowed (Fri Jan 20th, 2012)
- Hot add CPU (Fri Jan 26th, 2012)
- Fuzzy Lookup Transformation in Integration Services (Fri Feb 3th, 2012)
- Up to 8 CPU sockets (Fri Feb 10th, 2012)
- Support for Data Compression & Vardecimal Storage Format (Fri Feb 17th, 2012)
- Database Snapshot (Fri Feb 24th, 2012)
- Transparent Data Encryption (Fri Mar 2nd, 2012)
- Change Data Capture (Fri Mar 9th, 2012)