Specifications
SQL Server 2008 R2 Editions CHAPTER 1 13
■
Standard 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.
Specialized Editions
SQL Server 2008 R2 continues to deliver specialized editions for organizations that have
unique sets of requirements.
■
Developer 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.
■
Web 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 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 ofce 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.
■
Express 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.