SQL Server 2008 R2 now has three types of editions:
- Premium Editions
- Core Editions
- Specialised Editions
- SQL
Server 2008 R2 Datacenter Edition
- SQL Server 2008 R2 Parallel Data Warehouse Edition
- SQL Server 2008 R2 Enterprise Edition
- SQL Server 2008 R2 Standard Edition
- SQL Server 2008 R2 Developer Edition
- SQL Server 2008 R2 Web Edition
- SQL Server 2008 R2 Workgroup Edition
- SQL Server 2008 R2 Express Edition
- SQL Server 2008 R2 Compact Edition
SQL Server 2008 R2 Standard now has compressed backups.
SQL Server 2008 R2 Express Edition now has a 10GB limit as opposed to a 4GB data file limit in SQL Server 2008 Express and SQL Server 2005 Express.