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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.