Friday, May 28, 2010

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

No comments: