O'Reilly logo

SQL Server 2008: Administration in Action by Rod Colledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 1.1. Scalability and high availability features in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required