Microsoft SQL Server 2008 R2 810-08230 User Manual

■

  SQL Server 2008 R2 Standard is a complete data management and BI 

platform that provides medium-class solutions for smaller organizations . It does not 
include all the bells and whistles included in Datacenter and Enterprise; however, it 
continues to offer best-in-class ease of use and manageability . Backup compression, 
which was an enterprise feature with SQL Server 2008, is now a feature included with 
the SQL Server 2008 R2 Standard . Compared to Datacenter and Enterprise, Standard 
supports only up to four processors, up to 64 GB of RAM, one virtual machine, and two 
failover clustering nodes .

SQL Server 2008 R2 continues to deliver specialized editions for organizations that have 
unique sets of requirements .

■

  Developer includes all of the features and functionality found in Data-

center; however, it is strictly meant to be used for development, testing, and demon-
stration purposes only . It is worth noting that it is possible to transition a SQL Server 
Developer installation that is used for testing or development purposes directly into 
production by upgrading it to SQL Server 2008 Enterprise without reinstallation .

■

  At a much more affordable price compared to Datacenter, Enterprise, and Stan-

dard, SQL Server 2008 R2 Web is focused on service providers hosting Internet-facing 
Web serving environments . Unlike Workgroup and Express, this edition doesn’t have 
a small database size restriction, and it supports four processors and up to 64 GB of 
memory . SQL Server 2008 R2 Web does not offer the same premium features found in 
Datacenter, Enterprise, and Standard; however, it is still the ideal platform for hosting Web 
sites and Web applications .

■

  Workgroup is the next SQL Server 2008 R2 edition and is one step be-

low the Web edition in price and functionality . It is a cost-effective, secure, and reliable 
database and reporting platform meant for running smaller workloads than Stan-
dard. For example, this edition is ideal for branch office solutions such as branch data 
storage, branch reporting, and remote synchronization . Similar to Web, it supports a 
maximum database size of 524 terabytes; however, it supports only two processors 
and up to 4 GB of RAM . It is worth noting that it is possible to upgrade Workgroup to 
Standard or Enterprise .

■

  This free edition is the best entry-level alternative for independent software 

vendors, nonprofessional developers, and hobbyists building client applications . This 
edition is integrated with Visual Studio and is great for individuals learning about data-
bases and how to build client applications . Express is limited to one processor, 1 GB of 
memory, and a maximum database size of 10 GB .