I had created an old post about Enterprise only features of SQL server. As I found out interesting features, I added it to that old post. Today, I found out an MSDN link that has a feature comparison table which summarizes everything I was trying to capture in that post.
The link above is for the 2008 R2 version. You can switch between 2008, 2008 R2, and 2012.
As of 2012, the different editions of SQL server are:
- Business Intelligence
- Express with Advanced Services
- Express with Tools
I thought the PDW was like the top most edition, but apparently, it is marketed as an appliance.