Number of CPUs

OS maximum

8

4

4

2

1

1

1

Maximum memory utilized

OS maximum

2 TB

64 GB

64 GB

4 GB

1 GB

1 GB

1 GB

Maximum database size

524 PB

524 PB

524 PB

524 PB

524 PB

10 GB

10 GB

10 GB

IA64 hardware support

Yes

Yes

Resource governor

Yes

Yes

Table and index partitioning

Yes

Yes

Parallel index operations

Yes

Yes

Parallel consistency checks (DBCC)

Yes

Yes

Enhanced read-ahead scan

Yes

Yes

Scalable shared databases

Yes

Yes

Direct query of index views using NOEXPAND hint

Yes

Yes

Yes

Automatic indexed view maintenance

Yes

Yes

Yes

Automatic use of indexed views by query optimizer

Yes

Yes

Distributed Partition Views

Yes

Yes

Online system changes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Log shipping

Yes

Yes

Yes

Yes

Yes

Database mirroring2

Yes

Yes

Yes (single thread, synchronous only)

Witness only

Witness only

Witness only

Witness only

Witness only

Automatic corruption recovery from mirror

Yes

Yes

Yes

Log stream compression

Yes

Yes

Yes

Number of Failover clustering nodes

Operating system maximum1

Operating system maximum1

2 nodes

Backup compression

Yes

Yes

Yes3

Mirrored backups

Yes

Yes

Database snapshots

Yes

Yes

Fast recovery

Yes

Yes

Online indexing

Yes

Yes

Online page and file restore

Yes

Yes

Online configuration of Peer to Peer nodes

Yes

Yes

Hot add memory and CPU support

Yes

Yes

Hypervisor support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Guest failover clustering support for virtualization

Yes

Yes

Yes

Hyper-V live migration

Yes

Yes

Yes

Application mobility

Yes

Yes

Snapshot replication

Yes

Yes

Yes

Subscriber only

Yes

Subscriber only

Subscriber only

Subscriber only

Merge replication

Yes

Yes

Yes

Subscriber only

Restricted¹

Subscriber only

Subscriber only

Subscriber only

Transactional replication

Yes

Yes

Yes

Subscriber only

Restricted¹

Subscriber only

Subscriber only

Subscriber only

SQL Server change tracking

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Publishing data from SQL Server to non SQL Server subscribers

Yes

Yes

Yes

Publishing data from Oracle to SQL Server

Yes

Yes

Peer to Peer replication

Yes

Yes

Windows Integrated Authentication (including Kerberos)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration with Microsoft baseline security analyzer

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

C2 compliant audit mode1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Common criteria compliance

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data encryption and key management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Module signing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Transport Layer Security channel encryption

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Windows password policy support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

User-schema separation

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Login triggers and connection endpoints

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Secure configuration through policy-based management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server audit (fine-grained auditing)

Yes

Yes

Transparent database encryption

Yes

Yes

Extensible key management

Yes

Yes

Policy-Based Management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

PowerShell support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Object (SMO)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SysPrep support1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server connection director

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Dedicated admin connection

Yes

Yes

Yes

Yes

Yes

Yes (Under trace flag)

Yes (Under trace flag)

Yes (Under trace flag)

Policy automation (check on schedule and change)

Yes

Yes

Yes

Yes

Yes

Maintenance plans

Yes

Yes

Yes

Yes

Yes

Database mail

Yes

Yes

Yes

Yes

Yes

Performance data collector

Yes

Yes

Yes

Yes

Yes

System Center Operations Manager Management Pack

Yes

Yes

Yes

Yes

Yes

Plan guides

Yes

Yes

Yes

Yes

.

User instances

Yes

Yes

Yes

Support for data-tier application (DAC) operations - extract, deploy, upgrade

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Able to enroll for multi-instance management.

Yes1

Yes2

Yes

Yes

Yes

Multi-instance dashboard views and drilldowns

Yes

Yes2

Policy-based resource utilization evaluation

Yes

Yes2

SQL Server Configuration Manager

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL CMD (command prompt tool)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Migration Assistant1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Studio2

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Agent

Yes

Yes

Yes

Yes

Yes

Database Engine Tuning Advisor

Yes

Yes

Yes

Yes

Yes

SQL Server Profiler

Yes

Yes

Yes

Yes

Yes

No3

No3

No3

Analysis Services, PowerPivot IT operation dashboard

Yes

Yes

Microsoft Visual Studio Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

IntelliSense (Transact-SQL and MDX)

Yes

Yes

Yes

Yes

Yes

Yes

No

(SSMS is not installed with this edition)

Business Intelligence Development Studio

Yes

Yes

Yes

Yes

Yes

Yes

SQL query, edit and design tools

Yes

Yes

Yes

Yes

Version control support

Yes

Yes

Yes

Yes

MDX edit, debug, and design tools

Yes

Yes

Yes

Entity Framework support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Common language runtime (CLR) integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Native XML support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

XML indexing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

MERGE and UPSERT capabilities

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

FILESTREAM support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Date and Time data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Internationalization support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Full-text search

Yes

Yes

Yes

Yes

Yes

Yes

Specification of language in query

Yes

Yes

Yes

Yes

Yes

Yes

Service Broker (messaging)

Yes

Yes

Yes

Client only

Yes

Client only

Client only

Client only

XML/A support

Yes

Yes

Yes

Web services (HTTP/SOAP endpoints)

Yes

Yes

Yes

T-SQL endpoints

Yes

Yes

Yes

Planar and geodetic data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Spatial indexes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Advanced spatial libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Import/export of industry-standard spatial data formats

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Spatial results tab within SQL Server Management Studio

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Premium edition

Yes

Standard edition

Yes

Yes

SQL Server Import and Export Wizard

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Built-in data source connectors

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration Services designer and runtime

Yes

Yes

Yes

Basic tasks and transformations in addition to those used by the Import and Export Wizard

Yes

Yes

Yes

Log providers and logging

Yes

Yes

Yes

Basic data profiling tools

Yes

Yes

Yes

Programmable object model for extensibility

Yes

Yes

Yes

High performance Oracle destination

Yes

Yes

High performance Teradata destination

Yes

Yes

SAP BW source and destination

Yes

Yes

Data mining model training destination adapter

Yes

Yes

Dimension processing destination adapter

Yes

Yes

Partition processing destination adapter

Yes

Yes

Persistence (high performance) lookups

Yes

Yes

Data mining query transformation

Yes

Yes

Fuzzy grouping and lookup transformations

Yes

Yes

Term extractions and lookup transformations

Yes

Yes

Auto-generate staging and data warehouse schema

Yes

Yes

Yes

Change data capture

Yes

Yes

Data compression

Yes

Yes

Star join query optimization

Yes

Yes

Automatic use of indexed views by query optimizer

Yes

Yes

Scalable read-only AS configuration

Yes

Yes

Proactive caching

Yes

Yes

Parallel query processing on partitioned tables and indices

Yes

Yes

Partitioned cubes

Yes

Yes

Distributed partitioned cubes

Yes

Yes

SQL Server Analysis Services backup

Yes

Yes

Yes

Dimension, attribute relationship, aggregate, and cube design

Yes

Yes

Yes

Translations

Yes

Yes

Yes

Personalization extensions

Yes

Yes

Yes

SQL Server PowerPivot for SharePoint

Yes

Yes

Financial aggregations

Yes

Yes

Partitioned cubes and distributed partitioned cubes

Yes

Yes

Custom rollups

Yes

Yes

Semi-additive measures

Yes

Yes

Writeback dimensions

Yes

Yes

Linked measures and dimensions

Yes

Yes

Binary and compressed XML transport

Yes

Yes

Yes

Account intelligence

Yes

Yes

Perspectives

Yes

Yes

Scalable shared databases

Yes

Yes

Comprehensive set of data mining algorithms

Yes

Yes

Yes

Integrated data mining tools: wizards, editors, model viewers, query builder

Yes

Yes

Yes

Cross validation

Yes

Yes

Advanced configuration and tuning options for data mining algorithms

Yes

Yes

Support for pipeline data mining and text mining with Integration Services

Yes

Yes

Support for plug-in algorithms

Yes

Yes

Parallel model processing

Yes

Yes

Sequence prediction

Yes

Yes

Reporting Services memory limits

OS Maximum

OS Maximum

OS Maximum

4 GB

4 GB (x64) OS Maximum (x32)

4 GB

Allowed catalog DB SQL Server edition

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Web

SQL Server Workgroup

SQL Server Express

Allowed data source SQL Server edition

All

All

All

SQL Server Web

SQL Server Workgroup

SQL Server Express

Report server

Yes

Yes

Yes

Yes

Yes

Yes

Report Designer

Yes

Yes

Yes

Yes

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes

Yes

Yes

Reports as data feeds

Yes

Yes

Yes

Yes

Yes

Yes

Enhanced gauges and charting

Yes

Yes

Yes

Yes

Yes

Yes

Maps and map layers

Yes

Yes

Yes

Yes

Yes

Yes

Custom authentication

Yes

Yes

Yes

Yes

Yes

Yes

Export to Excel, Word, PDF, and images

Yes

Yes

Yes

Yes

Yes

Yes

Role Based Security

Yes

Yes

Yes

Yes

Yes

Yes

Create Custom Roles

Yes

Yes

Yes

No (Fixed roles only)

No (Fixed roles only)

No (Fixed roles only)

Model support

Yes

Yes

Yes

Yes

Yes

Model Item Security

Yes

Yes

Yes

Infinite click-through

Yes

Yes

Yes

E-mail and file share subscriptions and scheduling

Yes

Yes

Yes

Report history, executing snapshots, and caching

Yes

Yes

Yes

SharePoint integration

Yes

Yes

Yes

Shared component library

Yes

Yes

Yes

Remote and non-relational data source support

Yes

Yes

Yes

Data source, delivery, and rendering extensibility

Yes

Yes

Yes

Report definition customization extension (RDCE)

Yes

Yes

Yes

Data-driven report subscriptions

Yes

Yes

Scale out deployment (Web farms)

Yes

Yes

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Report Builder 3.0

Yes

Yes

Yes

Yes

Excel 2007 and Visio 2007 Add-in support

Yes

Yes

Yes

PowerPivot for Excel

Yes

Yes

Master Data Services database

Yes

Yes

Master Data Manager Web application

Yes

Yes

Master Data Services Web service

Yes

Yes

 Stay Up to Date with SQL Server Install, and Upgrade information

For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page

For automatic notification of these updates, subscribe to the RSS feeds available on the page.