Αλλαγές στις εκδόσεις Standard και Enterprise του SQL Server 2008 R2
| Standard | Enterprise | |
| Position in product lineup | Unchanged. Mid-tier offering for midsize businesses and departmental usage | Changed. New Datacenter edition displaces Enterprise as top-of-the-line offering |
| Maximum accessible memory | Reduced to 64GB; SQL Server Standard 2008 supported OS maximum of 2TB | Unchanged. 2TB |
| Maximum number of processors | Unchanged at four processors | Reduced to eight processors; SQL Server 2008 Enterprise supports OS maximum of 64 |
| Server-CAL pricing | Unchanged. US$898 for server license, US$164 for SQL Server 2008 R2 CAL | Unchanged. US$8,592 for server license, US$164 for SQL Server 2008 R2 CAL |
| Per-processor pricing | Increased. US$7,171; up 25% from US$5,737 | Increased. US$27,498; up 15% from US$23,910 |
| Virtualization rights | Unchanged. Each per-server or per-processor license covers SQL Server use within one virtual machine (VM) only | Reduced to four VMs per server license or per-processor license; SQL Server 2008 Enterprise licenses provide rights to run unlimited VMs on licensed server |
| License reassignment rules | Unchanged. Generally can't reassign a per-server or per-processor license between computers more often than once every 90 days | Unchanged. Licenses within a server farm can be reassigned freely from one machine to another |
| Downgrade rights | Unchanged. Can downgrade to earlier versions of SQL Server Standard | Improved. Can downgrade to older versions and lesser editions; SQL Server 2008 Enterprise licenses provide the right to a version downgrade but not for substituting a lesser edition |
| Major features added | - StreamInsight (Basic) - Backup compression |
- StreamInsight (Basic) - Master Data Services - Application and multiserver management for up to 25 instances - PowerPivot for SharePoint - Compression of Unicode-encoded data |