Partitioning

Yes

Data compression

Yes

Resource governor

Yes

Partition table parallelism

Yes

Multi-instance support

50

16

16

16

16

16

16

Online system changes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Backup log shipping

Yes

Yes

Yes

Yes

Database mirroring2

Yes (full)

Yes (safety full only)

Witness only

Witness only

Witness only

Witness only

Witness only

Failover clustering

Operating system maximum1

2 nodes

Dynamic AWE

Yes

Yes

Failover without client configuration

Yes

Yes

Automatic corruption recovery from mirror

Yes

Yes

Database snapshots

Yes

Fast recovery

Yes

Online indexing

Yes

Online restore

Yes

Mirrored backups

Yes

Hot add memory

Yes

Online configuration of P2P nodes

Yes

Hot add CPU

Yes

Backup compression

Yes

C2 audit mode

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server auditing

Yes

Transparent database encryption

Yes

ISV encryption (off-box key management)

Yes

Merge replication

Yes

Yes

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Transactional replication

Yes

Yes

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Snapshot replication

Yes

Yes

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Subscriber only

SQL Server change tracking

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Heterogeneous subscribers

Yes

Yes

Oracle publishing

Yes

P2P transactional replication

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)

Policy-based configuration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Policy-based management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Performance data collection and warehouse

Yes

Yes

Yes

Yes

Standard performance reports

Yes

Yes

Plan guides

Yes

Yes

Plan freezing for plan guides

Yes

Yes

Policy-based best practices

Yes

Yes

Multi-server policy-based management

Yes

Yes

Distributed partition views

Yes

Parallel index operations

Yes

Automatic query-to-indexed-view matching

Yes

Parallel database backup checksum check

Yes

Database mail

Yes

Yes

Yes

Yes

SQL Server management objects (SMO)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Configuration Manager

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL CMD (command prompt tool)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Studio

Yes

Yes

Yes

Yes (Basic version)

Yes (Basic Version)

Yes (Basic version)

SQL Server Profiler

Yes

Yes

Yes

Yes

SQL Server Agent

Yes

Yes

Yes

Yes

Database Tuning Advisor

Yes

Yes

Yes

Yes

Microsoft Operations Manager Pack

Yes

Yes

Yes

Yes

Microsoft Visual Studio Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL query and edit and design tools

Yes

Yes

Yes

Intellisense (Transact-SQL and MDX)

Yes

Yes

Yes

Version control support

Yes

Yes

Yes

Business Intelligence Development Studio

Yes

Yes

MDX edit, debug, and design tools

Yes

Yes

Common language runtime (CLR) integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Native XML support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

XML indexing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

MERGE and UPSERT capabilities

Yes

Yes

Yes

Yes

Yes

Yes

Yes

FILESTREAM support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Date and Time data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Internationalization support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Full-text search

Yes

Yes

Yes

Yes

Yes

Specification of language in query

Yes

Yes

Yes

Yes

Yes

Service Broker (messaging)

Yes

Yes

Yes

Client only

Client only

Client only

Client only

XML/A support

Yes

Yes

Web services (HTTP/SOAP endpoints)

Yes

Yes

Spatial indexes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Geodetic data type

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Advanced spatial libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Standards-based spatial support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Import and Export Wizard with basic sources and destinations and Execute SQL task

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration Services runtime

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration Services API and object model

Yes

Yes

Yes

Yes

SSIS Designer including VSTA scripting

Yes

Yes

Integration Services service, wizards, and command prompt utilities

Yes

Yes

Basic tasks and transformations

Yes

Yes

Log providers and logging

Yes

Yes

Data profiling tools

Yes

Yes

Additional sources and destinations:

Raw File source

XML source

DataReader destination

Raw File destination

Recordset destination

SQL Server Compact destination

SQL Server destination

Yes

Yes

Advanced sources, transformations, and destinations:

Data Mining Query transformation

Fuzzy Lookup and Fuzzy Grouping transformations

Term Extraction and Term Lookup transformations

Data Mining Model Training destination

Dimension Processing destination

Partition Processing destination

Yes

Create cubes without a database

Yes

Yes

Auto-generate staging and data warehouse schema

Yes

Yes

Attribute relationship designer

Yes

Yes

Efficient aggregation designers

Yes

Yes

Change data capture

Yes

Star join query optimization

Yes

Scalable read-only AS configuration

Yes

Proactive caching

Yes

Auto parallel partition processing

Yes

Partitioned cubes

Yes

Distributed partitioned cubes

Yes

SQL Server Analysis Services service

Yes

Yes

SQL Server Analysis Services backup

Yes

Yes

General performance/scale improvements

Yes

Yes

Dimension, attribute relationship, aggregate, and cube design improvements

Yes

Yes

Personalization extensions

Yes

Yes

Financial aggregations

Yes

Partitioned customers

Yes

Custom rollups

Yes

Semi-additive measures

Yes

Writeback dimensions

Yes

Linked measures and dimensions

Yes

Binary and compressed XML transport

Yes

Account intelligence

Yes

Perspectives

Yes

Analysis Services shared, scalable databases

Yes

Standard algorithms

Yes

Yes

Data mining tools: wizards, editors, query builders

Yes

Yes

Cross validation

Yes

Models on filtered subsets of mining structure data

Yes

Time series: custom blending between ARTXP and ARIMA models

Yes

Time series: prediction with new data

Yes

Unlimited concurrent datamining queries

Yes

Advanced configuration and tuning for algorithms

Yes

Algorithm plug-in API

Yes

Parallel model processing

Yes

Time series: cross-series prediction

Yes

Unlimited attributes for association rules

Yes

Sequence prediction

Yes

Multiple prediction targets for naïve Bayes, neural network, and logistic regression

Yes

Report server

Yes

Yes

Yes

Yes

Yes

Report Designer

Yes

Yes

Yes

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes (Report Manager)

Yes (Report Manager)

Role-based security

Yes

Yes

Yes (Fixed roles)

Yes (Fixed roles)

Yes (Fixed roles)

Ad-hoc reporting (Report builder)

Yes

Yes

Yes

Word export and enhanced text formatting

Yes

Yes

Yes

Yes

Yes

Enterprise-scale reporting engine

Yes

Yes

Yes

Yes

Yes

IIS-agnostic report deployment

Yes

Yes

Yes

Yes

Yes

Updated management tools

Yes

Yes

Yes

Yes

Yes

Report definition customization extension (RDCE)

Yes

Yes

Yes

Yes

Yes

SharePoint integration

Yes

Yes

Enhanced SSRS gauges and charting

Yes

Yes

Yes

Yes

Yes

Custom authentication

Yes

Yes

Yes

Yes

Export to Excel, PDF, and images

Yes

Yes

Yes

Yes

Yes

Remote and non-relational data source support

Yes

Yes

E-mail and file share delivery

Yes

Yes

Report history, scheduling, subscriptions, and caching

Yes

Yes

Data source, delivery, and rendering extensibility

Yes

Yes

Scale out (Web farms)

Yes

Infinite click-through

Yes

Data-driven subscriptions

Yes

Reporting Services memory limits

Unlimited

Unlimited

4 GB

4 GB

4 GB