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...)
- Data & Index Compression
- Backup Compression (although this is available in the STANDARD edition of SQL 2008 R2)
- Table Partitioning
- Online Index Rebuilds
- Resource Governor