Features Supported by the Editions of SQL Server 2012

Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)¹

Operating System maximum

Limited to lesser of 4 Sockets or 16 cores

Limited to lesser of 4 Sockets or 16 cores

Limited to lesser of 4 Sockets or 16 cores

Limited to lesser of 1 Socket or 4 cores

Limited to lesser of 1 Socket or 4 cores

Limited to lesser of 1 Socket or 4 cores

Maximum memory utilized (per instance of SQL Server Database Engine)

Operating system maximum

64 GB

64 GB

64 GB

1 GB

1 GB

1 GB

Maximum memory utilized (per instance of Reporting Services)

Operating system maximum

Operating system maximum

64 GB

64 GB

4 GB

N/A

N/A

Server Core support¹

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Database mirroring

Yes

Yes (Safety Full Only)

Yes (Safety Full Only)

Witness only

Witness only

Witness only

Witness only

Backup compression

Yes

Yes

Yes

AlwaysOn Availability Groups

Yes

Online page and file restore

Yes

Online schema change

Yes

Mirrored backups

Yes

Database Recovery Advisor

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Multi-instance support

50

50

50

50

50

50

50

Data compression

Yes

Partition Table Parallelism

Yes

Basic Auditing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Transparent database encryption

Yes

User-Defined Roles

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server change tracking

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Transactional replication

Yes

Yes

Yes

Yes (Subscriber only)

Yes (Subscriber only)

Yes (Subscriber only)

Yes (Subscriber only)

Heterogeneous subscribers

Yes

Yes

Yes

Peer to Peer transactional replication

Yes

SQL Management Objects (SMO)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL CMD (Command Prompt tool)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Distributed Replay – Admin Tool

Yes

Yes

Yes

Yes

Yes

Yes

Distributed Replay - Controller

Yes (Enterprise supports up to 16 clients, Developer supports only 1 client)

No

Yes (1 client support only)

Yes (1 client support only)

SQL Server Agent

Yes

Yes

Yes

Yes

Database Tuning Advisor (DTA)

Yes

Yes

Yes³

Yes³

User Instances

Yes

Yes

Yes

Dedicated admin connection

Yes

Yes

Yes

Yes

Yes (under trace flag)

Yes (under trace flag)

Yes (under trace flag)

SysPrep support¹

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Policy automation (check on schedule and change)

Yes

Yes

Yes

Yes

Able to enroll as a managed instance in a multi-instance management

Yes

Yes

Yes

Yes

Plan guides and plan freezing for plan guides

Yes

Yes

Yes

Yes

Automatic indexed view maintenance

Yes

Yes

Yes

Yes

Parallel indexed operations

Yes

Parallel consistency check

Yes

Contained Databases

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Microsoft Visual Studio Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Data Tools (SSDT)

Yes

Yes

Yes

Yes

Yes

Version control support¹

Yes

Yes

Yes

Common Language Runtime (CLR) Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

XML indexing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

FILESTREAM support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Date and Time datatypes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Full-text and semantic search

Yes

Yes

Yes

Yes

Yes

Service Broker (messaging)

Yes

Yes

Yes

No (Client only)

No (Client only)

No (Client only)

No (Client only)

TSQL endpoints

Yes

Yes

Yes

Yes

SQL Server Import and Export Wizard

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SSIS designer and runtime

Yes

Yes

Yes

Basic data profiling tools

Yes

Yes

Yes

Change Data Capture Designer for Oracle by Attunity

Yes

High performance Oracle destination

Yes

SAP BW source and destination

Yes

Dimension processing destination adapter

Yes

Change Data Capture components by Attunity

Yes

Persistent (high performance) lookups

Yes

Fuzzy grouping and lookup transformations

Yes

Master Data Services database

Yes

Yes

Create cubes without a database

Yes

Yes

Yes

Change data capture

Yes

Scalable read-only Analysis Services configuration

Yes

xVelocity memory optimized columnstore indexes

Yes

Scalable Shared Databases (Attach/Detach, Read only databases)

Yes

Yes

Synchronize databases

Yes

Yes

Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL)

Yes

Yes

Yes

Semi-additive Measures

Yes

Yes

No¹

KPIs

Yes

Yes

Yes

Actions

Yes

Yes

Yes

Time Intelligence

Yes

Yes

Yes

Writeback cube

Yes

Yes

Yes

Writeback cells

Yes

Yes

Yes

Advanced hierarchy types (Parent-Child, Ragged Hiearchies)

Yes

Yes

Yes

Linked measures and dimensions

Yes

Yes

Aggregations

Yes

Yes

Yes

Proactive Caching

Yes

Yes

MDX queries and scripts

Yes

Yes

Yes

Dimension and Cell-level Security

Yes

Yes

Yes

MOLAP, ROLAP, HOLAP storage modes

Yes

Yes

Yes

Push-mode processing

Yes

Yes

Hierarchies

Yes

Yes

Perspectives

Yes

Yes

Row-level Security

Yes

Yes

In-Memory and DirectQuery storage modes (Tabular only)

Yes

Yes

SharePoint farm integration based on shared service architecture

Yes

Yes

Health monitoring rules

Yes

Yes

PowerPivot Data Refresh

Yes

Yes

Standard Algorithms

Yes

Yes

Yes

Cross Validation

Yes

Yes

Time Series: Custom Blending Between ARTXP and ARIMA Methods

Yes

Yes

Unlimited Concurrent DM Queries

Yes

Yes

Support for plug-in algorithms

Yes

Yes

Time Series: Cross-Series Prediction

Yes

Yes

Sequence Prediction

Yes

Yes

Supported catalog DB SQL Server edition

Standard or higher

Standard or higher

Standard or higher

Web

Express

Report server

Yes

Yes

Yes

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes

Yes

Word Export and Rich Text Support¹

Yes

Yes

Yes

Yes

Yes

Export to Excel, PDF, Images, and Atom compliant data feeds²

Yes

Yes

Yes

Yes

Yes

Rendering to interactive HTML.

Yes

Yes

Yes

Yes

Yes

Report as data feeds

Yes

Yes

Yes

Yes

Yes

Create custom roles for role-based security

Yes

Yes

Yes

Infinite click through

Yes

Yes

Yes

Email and file share subscriptions and scheduling

Yes

Yes

Yes

SharePoint Integration

Yes

Yes

Yes

Data source, delivery and rendering, RDCE extensibility

Yes

Yes

Yes

Scale out deployment (Web farms)

Yes

Yes

Power View⁴

Yes

Yes

Enterprise

Standard, Business Intelligence Enterprise, editions (local or remote)

Standard

Standard, Enterprise editions (local or remote)

Express with Advanced Services

Express with Advanced Services (local only).

Report Builder

Yes

Yes

Yes

PowerPivot for Excel 2010

Yes

Yes

Spatial indexes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Advanced spatial libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Migration Assistant

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data Quality Services

Yes

Yes

StreamInsight HA

StreamInsight Premium Edition