1.2. Editions and features
Like earlier versions, the major editions of SQL Server are Enterprise and Standard, with a number of other specialized editions. Let's briefly walk through the editions, noting the significant features and limitations of each.
1.2.1. Enterprise
The edition of choice for mission-critical database systems, the Enterprise edition offers all the SQL Server features, including a number of features not available in any other edition, such as data and backup compression, Resource Governor, database snapshots, Transparent Data Encryption, and online indexing. Table 1.1 summarizes the scalability and high availability features available in each edition of SQL Server.
Get SQL Server 2008 Administration in Action 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.