SQL Server 2005 Options
Like Windows, SQL Server also comes in a variety of editions. These editions allow you to choose the features and functionality that you need and avoid paying for features that you don’t need. SQL Server 2005 is available in Express, Developer, Mobile, Workgroup, Standard, and Enterprise Editions. This book is geared more towards the server market, so we won’t cover Express, Developer, Mobile, and Workgroup Editions in this chapter. Some of the key differences between the editions are shown in Table 5-6.
Table 5-6. SQL Server 2005 Editions
Feature | Standard Edition | Enterprise Edition |
|---|---|---|
Maximum RAM | OS maximum | OS maximum |
Maximum number of CPUs | 4 | Unlimited |
Partitioning | No | Yes |
Parallel index operations | No | Yes |
Indexed views | No | Yes |
Mirroring and clustering ... |
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
