SQL Server 2008 Editions and Downscaling

l'm having to look at downscaling the SQL infrastructure.

Not surprisingly, the cost of Enterprise edition is a large issue for a small company. Expecially when you factor number of processors and the need for multiple environments. Consolidation and downscaling are therefore the order of the day.

Cost aside, what FUNCTIONALITY will I stand to lose? (and miss, sob...)

1. Data & Index Compression
2. Backup Compression (although this is available in the STANDARD edition of SQL 2008 R2)
3. Table Partitioning
4. Online Index Rebuilds
5. Resource Governor

ref : Features Supported by the Editions of SQL Server 2008

Bookmark : Top 10 Features of SQL 2008 R2

Don Schlichting sumarises his 'Top 10 Features of SQL 2008 R2' and explains briefly what they are.

1. Report Builder 3.0

2. SQL Server 2008 R2 Datacenter

3. SQL Server 2008 R2 Parallel Data Warehouse

4. StreamInsight

5. Master Data Services

6. PowerPivot for SharePoint

7. Data-Tier Application

8. Unicode Compression

9. SQL Server Utility

10. Multi Server Dashboards