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.