SQL Server 2008 R2 Editions
You can choose from several editions of SQL Server 2008 R2. The edition you choose depends on your database and data processing needs, as well as the Windows platform on which you want to install it. For actual deployment of SQL Server in a production environment, you can choose from any edition of SQL Server 2008 except Developer Edition and Evaluation Edition. Which edition you choose to deploy depends on your system requirements and need for SQL Server components. This following sections examine the different editions of SQL Server and discusses their features and capabilities. Using this information, you can better choose which edition provides the appropriate solution for you.
SQL Server 2008 Standard Edition
The Standard Edition of SQL Server 2008 is the version intended for the masses—those running small- to medium-sized systems who don’t require the performance, scalability, and availability provided by Enterprise Edition. Standard Edition scalability is limited to up to four processors. There is no built-in memory limitation in SQL Server 2008 Standard Edition; it can utilize as much memory as provided by the operating system.
SQL Server 2008 Standard Edition includes the following features:
The Standard Edition can be installed on any of the Windows 2003 SP2 and Windows 2008 Server platforms, as well as Windows XP Professional, Windows Vista Ultimate, Enterprise, or Business Editions, and Windows 7 Ultimate, Enterprise, or Professional Editions. The
Standard Edition should meet the needs of most departmental and small- to mid-sized applications. However, if you need more scalability, availability, advanced security or performance features, or comprehensive analysis features, you should implement the Enterprise Edition of SQL Server 2008.
SQL Server 2008 Enterprise Edition
The Enterprise Edition of SQL Server 2008 is the most comprehensive and complete edition available. It provides the most scalability and availability of all editions and is intended for systems that require high performance and availability, such as large-volume websites, data warehouses, and high-throughput online transaction processing (OLTP) systems.
SQL Server 2008 Enterprise Edition supports as much memory and as many CPUs as supported by the operating system on which it is installed. It can be installed on any of the Windows 2003 SP2 and Windows 2008 Server platforms.
In addition, SQL Server 2008 Enterprise Edition provides performance enhancements, such as parallel queries, indexed views, and enhanced read-ahead scanning.
Which version is right for you? The next section explores the feature sets of Enterprise and Standard Editions so you can decide which one provides the features you need
Differences Between the Enterprise and Standard Editions of SQL Server
For deploying SQL Server 2008 in a server environment, either the Standard Edition or Enterprise Edition of SQL Server is a logical choice. To help you decide between the two editions, Table 1.1 compares the major features that each edition supports.
Other SQL Server 2008 Editions
The Standard and Enterprise Editions of SQL Server 2008 are intended for server-based deployment of applications. In addition, the following editions are available for other specialized uses:
Now lets see one by one
SQL Server 2008 Workgroup Edition is intended for small organizations that need a database with no limits on database size or number of users but may not need the full capabilities of the Standard Edition. SQL Server 2008 Workgroup Edition can be used as a front-end web server or for departmental or branch office applications.
Workgroup Edition includes most of the core database features and capabilities of the SQL Server Standard Edition except for the following:
Workgroup Edition can be installed in any of the following environments:
The Developer Edition of SQL Server 2008 is a full-featured version intended for development and end-user testing only. It includes all the features and functionality of Enterprise Edition, at a much lower cost, but the licensing agreement prohibits production deployment of databases using Developer Edition. To provide greater flexibility during development, Developer Edition can be installed in any of the following environments.
Web Edition SQL
Server 2008 Web Edition is a lower total-cost-of-ownership option, similar to the Workgroup Edition, but intended for small- to large-scale web hosts and websites.
Web Edition includes most of the core database features and capabilities of the SQL Server Standard Edition with the following key differences
Web Edition can be installed in any of the following environments.
Express Edition SQL
Server Express Edition is a free, lightweight, embeddable, and redistributable version of SQL Server 2008. It includes a stripped-down version of SQL Server Management Studio, called SQL Server Management Studio Express, for easily managing a SQL Server Express instance and its databases. The Express Edition of SQL Server 2008 is intended for users who are running applications that require a locally installed database, often on mobile systems, and who spend at least some time disconnected from the network. The core database engine of Express Edition is the same as the other SQL Server editions, so as your needs grow, your applications seamlessly work with the rest of the SQL Server product family.
The Express Edition can be installed in any of the following environments:
Express Edition supports most of the same features as the Workgroup Edition, with the following exceptions:
If you need a bit more than the Express Edition offers, but not as much as the Workgroup Edition, Microsoft also provides the Express Edition with Advanced Services. The Express Edition with Advanced Services includes support for Full-Text Search and limited support of Reporting Services for web reporting.
SQL Server Compact 3.5 Edition
SQL Server Compact 3.5 is a free, embedded version of SQL Server intended for building standalone and occasionally connected applications for mobile devices, desktops, and web clients on Windows platforms. The Compact 3.5 Edition provides general T-SQL compatibility and a costbased Query Optimizer similar to that in SQL Server 2008. Developers who are familiar with SQL Server 2008 should feel comfortable developing for SQL Server Compact 3.5.
SQL Server Compact 3.5 Edition has a small footprint, requiring only about 2–3MB. It can connect directly with a SQL Server 2008 database through remote execution of T-SQL statements, and it also supports replication with SQL Server 2008 databases as a merge replication subscriber so that data can be accessed and manipulated offline and synchronized later with a server-based version of SQL Server 2008.
SQL DBA School is strongly committed to providing complete practical training exclusively on Microsoft SQL Server and Datawarehousing technologies. SQL DBA School Training Institute established in February 2013 is now one of the best training institute offering SQL Server and T-SQL (SQL Server) Training, SQL Database Administration (SQL DBA) Training and Business Intelligence (MSBI / SQL BI) Training.
We have been working with numerous consultancies in USA & UK. We undertake training on SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 versions. We make sure that all our sessions are very much interactive and well structured with doubts clarifications during and after each course.
"An education equips a mind. A degree demonstrates its potential."
- IGNATIUS J. REILLY
"SQL DBA School presented me with all of the opportunities I needed to succeed."
- GEORGE BOWLING
"The sense of accomplishment I felt after completing my SQL DBA School courses was great!"
- TIM DOYLE