Online learning

​fREE

SQL DBA SCHOOL

Founder Abubeker Refaw

Different  Editions of SQL Server 

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: 

  • CLR procedures, functions, and data types 
  • SQL Server Analysis Services . Service Broker .
  • Reporting Services . SQL Server Integration Services 
  • Full-Text Search . Built-in XML support . Spatial Indexes 
  • SQL Server Profiler and performance analysis tools . SQL Server Management Studio . Policy Based Management . Replication . Two-node failover clustering 
  • Database mirroring (safety full mode only) 
  • Log shipping 
  • Backup Compression (available in R2 only) 


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:

  • Workgroup Edition
  • Developer Edition
  • Web Edition 
  • Express Edition
  • Compact Edition


Now lets see one by one


Workgroup Edition

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:

  • It is limited to two CPUs and a maximum of 4GB of memory. .
  • It does not support failover clustering.
  • Database mirroring support is limited to being a witness only.
  •  It does not include Analysis Services.
  • It provides limited support for Integration Services and Reporting Services features.

Workgroup Edition can be installed in any of the following environments:

  •  Any Windows 2003 Server editions 
  • Any Windows 2008 Server editions 
  • Windows 7
  • Windows Vista
  • Windows XP


Developer Edition

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. 

  • Any Windows 2003 Server editions
  • Any Windows 2008 Server editions
  • Windows 7
  • Windows Vista
  • Windows XP


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

  •  It is limited to a maximum of 4 CPUs.
  • Unlike the Workgroup Edition, memory in this edition is constrained only by the OS maximum memory limits.
  • It does not support failover clustering.
  • Database mirroring support is limited to being a witness only.
  • It does not include Analysis Services.
  •  It includes only the basic version of SQL Server Management Studio (which lacks advanced features such as IntelliSense and version control support).
  • It provides limited support for Integration Services and Reporting Services features. 


Web Edition can be installed in any of the following environments.

  • Any Windows 2003 Server editions
  • Any Windows 2008 Server editions
  • Windows 7 .
  • Windows Vista
  • Windows XP


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:

  • Any Windows 2003 Server editions
  • Any Windows 2008 Server editions
  • Windows 7
  • Windows Vista
  • Windows XP

Express Edition supports most of the same features as the Workgroup Edition, with the following exceptions:

  •  It is limited to using a maximum of one CPU and 1GB of memory.
  • It limits the maximum database size to 4GB.
  • It does not include Full-Text Search, Reporting Services, or Analysis Services.
  •  It does not include SQL Server Integration Services.
  • It supports Service Broker as a client only.
  • It does not include SSMS.
  • It can participate in replication only as a subscriber.


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.