features-supported-by-the-editions-of-sql-server-2014.md

title	Features Supported by the Editions of SQL Server 2014 | Microsoft Docs
ms.custom
ms.date	05/24/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	database-engine
ms.topic	conceptual
ms.assetid	5da61ff5-12b9-48e6-b3c8-0dacca1751c4
author	mightypen
ms.author	genemi
manager	craigg

Features Supported by the Editions of SQL Server 2014

This topic provides details of features supported by the different editions of [!INCLUDEssCurrent].

NOTE: [!INCLUDEssNoVersion] is available in an Evaluation edition for a 180-day trial period. For more information, see the [!INCLUDEssNoVersion] Trial Software Web Site.

NOTE: For features supported by Evaluation and Developer editions see the [!INCLUDEssNoVersion] Enterprise feature set.

To navigate to the table for a [!INCLUDEssNoVersion] technology, click on its link:

Cross-Box Scale Limits

High Availability

Scalability and Performance

Security

Replication

Management Tools

RDBMS Manageability

Development Tools

Programmability

Integration Services

Integration Services-Advanced Adapters

Integration Services-Advanced Transforms

Master Data Services

Data Warehouse

Analysis Services

BI Semantic Model (Multidimensional)

BI Semantic Model (Tabular)

PowerPivot for SharePoint

Data Mining

Reporting Services

Business Intelligence Clients

Spatial and Location Services

Additional Database Services

Other Components

Cross-Box Scale Limits

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Maximum Compute Capacity Used by a Single Instance ([!INCLUDEssNoVersion] Database Engine)1	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 Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1	Operating system maximum	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 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 [!INCLUDEssNoVersion] Database Engine)	Operating system maximum	128 GB	128 GB	64 GB	1 GB	1 GB	1 GB
Maximum memory utilized (per instance of [!INCLUDEssASnoversion])	Operating system maximum	Operating system maximum	64 GB	N/A	N/A	N/A	N/A
Maximum memory utilized (per instance of [!INCLUDEssRSnoversion])	Operating system maximum	Operating system maximum	64 GB	64 GB	4 GB	N/A	N/A
Maximum relational Database size	524 PB	524 PB	524 PB	524 PB	10 GB	10 GB	10 GB

¹ Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per [!INCLUDEssNoVersion] instance. There are no limits under the Core-based Server Licensing model. For more information, see Compute Capacity Limits by Edition of SQL Server.

High Availability

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Server Core support1	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Log Shipping	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
Database snapshot	Yes
Alwayson Failover Cluster Instances	Yes (Node support: Operating system maximum	Yes (Node support: 2)	Yes (Node support: 2)
AlwaysOn Availability Groups	Yes (up to 8 secondary replicas, including 2 synchronous secondary replicas)
Connection Director	Yes
Online page and file restore	Yes
Online indexing	Yes
Online schema change	Yes
Fast recovery	Yes
Mirrored backups	Yes
Hot Add Memory and CPU2	Yes
Database Recovery Advisor	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Encrypted Backup	Yes	Yes	Yes
Smart Backup	Yes	Yes	Yes	No

¹For more information on installing [!INCLUDEssCurrent] on Server Core, see Install SQL Server 2014 on Server Core.

²This feature is only available for 64-bit [!INCLUDEssNoVersion].

Scalability and Performance

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Multi-instance support	50	50	50	50	50	50	50
Table and index partitioning	Yes
Data compression	Yes
Resource Governor	Yes
Partition Table Parallelism	Yes
Multiple Filestream containers	Yes
NUMA Aware Large Page Memory and Buffer Array Allocation	Yes
Buffer Pool Extension 1	Yes	Yes	Yes
IO Resource Governance	Yes
In-Memory OLTP 1	Yes
Delayed durability	Yes	Yes	Yes	Yes	Yes	Yes	Yes

¹ This feature is only available for 64-bit [!INCLUDEssNoVersion].

Security

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Basic Auditing	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Fine Grained Auditing	Yes
Transparent database encryption	Yes
Extensible Key Management	Yes
User-Defined Roles	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Contained Databases	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Encryption for Backups	Yes	Yes	Yes

Replication

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEssNoVersion] change tracking	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Merge replication	Yes	Yes	Yes	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
Transactional replication	Yes	Yes	Yes	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
Snapshot replication	Yes	Yes	Yes	Yes (Subscriber only	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
Heterogeneous subscribers	Yes	Yes	Yes
Oracle publishing	Yes
Peer to Peer transactional replication	Yes

Management Tools

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
SQL Management Objects (SMO)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SQL Configuration Manager	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SQL CMD (Command Prompt tool)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
[!INCLUDEssNoVersion] Management Studio	Yes	Yes	Yes	Yes	Yes	Yes
Distributed Replay - Admin Tool	Yes	Yes	Yes	Yes	Yes	Yes
Distributed Replay - Client	Yes	No	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 Profiler	Yes	Yes	Yes	No2	No2	No2	No2
[!INCLUDEssNoVersion] Agent	Yes	Yes	Yes	Yes
Microsoft System Center Operations Manager Management Pack	Yes	Yes	Yes	Yes
Database Tuning Advisor (DTA)	Yes	Yes	Yes3	Yes3
Deploy a [!INCLUDEssNoVersion] Database to an Azure VM Wizard	Yes	Yes	Yes	Yes	Yes	Yes	Yes
[!INCLUDEssNoVersion] Data Files in Azure	Yes	Yes	Yes	Yes	Yes	Yes	Yes

² [!INCLUDEssNoVersion] Web, [!INCLUDEssExpress], [!INCLUDEssExpress] with Tools, and [!INCLUDEssExpress] with Advanced Services can be profiled using [!INCLUDEssNoVersion] Standard and [!INCLUDEssNoVersion] Enterprise editions.

³ Tuning enabled only on Standard edition features.

RDBMS Manageability

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
User Instances					Yes	Yes	Yes
LocalDB					Yes	Yes
Dedicated admin connection	Yes	Yes	Yes	Yes	Yes (under trace flag)	Yes (under trace flag)	Yes (under trace flag)
PowerShell scripting support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SysPrep support1	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Support for Data-tier application component operations - extract, deploy, upgrade, delete	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Policy automation (check on schedule and change)	Yes	Yes	Yes	Yes
Performance data collector	Yes	Yes	Yes	Yes
Able to enroll as a managed instance in a multi-instance management	Yes	Yes	Yes	Yes
Standard performance reports	Yes	Yes	Yes	Yes
Plan guides and plan freezing for plan guides	Yes	Yes	Yes	Yes
Direct query of indexed views (using NOEXPAND hint)	Yes	Yes	Yes	Yes
Automatic indexed view maintenance	Yes	Yes	Yes	Yes
Distributed partitioned views	Yes	Partial. Distributed Partitioned Views are not updatable	Partial. Distributed Partitioned Views are not updatable	Partial. Distributed Partitioned Views are not updatable	Partial. Distributed Partitioned Views are not updatable	Partial. Distributed Partitioned Views are not updatable	Partial. Distributed Partitioned Views are not updatable
Parallel indexed operations	Yes
Automatic use of indexed view by query optimizer	Yes
Parallel consistency check	Yes
[!INCLUDEssNoVersion] Utility control point	Yes
Contained Databases	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Buffer Pool Extension2	Yes	Yes	Yes

¹ For more information, see Considerations for Installing SQL Server Using SysPrep.

² This feature is only available for 64-bit [!INCLUDEssNoVersion].

Development Tools

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEmsCoName] Visual Studio Integration	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Intellisense ([!INCLUDEtsql] and MDX)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
[!INCLUDEssBIDevStudioFull]	Yes	Yes	Yes	Yes	Yes
SQL query edit and design tools1	Yes	Yes	Yes
Version control support1	Yes	Yes	Yes
MDX edit, debug, and design tools1	Yes	Yes	Yes

¹ This feature is not available for 64-bit version of Standard edition.

Programmability

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
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 & UPSERT Capabilities	Yes	Yes	Yes	Yes	Yes	Yes	Yes
FILESTREAM support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
FileTable	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Date and Time datatypes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Internationalization support	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Full-text and semantic search	Yes	Yes	Yes	Yes	Yes
Specification of language in query	Yes	Yes	Yes	Yes	Yes
Service Broker (messaging)	Yes	Yes	Yes	No (Client only)	No (Client only)	No (Client only)	No (Client only)
[!INCLUDEtsql] endpoints	Yes	Yes	Yes	Yes

Integration Services

Feature	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEssNoVersion] Import and Export Wizard	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Built-in data source connectors	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SSIS designer and runtime	Yes	Yes	Yes
Basic Transforms	Yes	Yes	Yes
Basic data profiling tools	Yes	Yes	Yes
Change Data Capture Service for Oracle by Attunity	Yes
Change Data Capture Designer for Oracle by Attunity	Yes

Integration Services - Advanced Adapters

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
High performance Oracle destination	Yes
High performance Teradata destination	Yes
SAP BW source and destination	Yes
Data mining model training destination adapter	Yes
Dimension processing destination adapter	Yes
Partition processing destination adapter	Yes
Change Data Capture components by Attunity	Yes
Connector for Open Database Connectivity (ODBC) by Attunity	Yes

Integration Services - Advanced Transforms

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Persistent (high performance) lookups	Yes
Data mining query transformation	Yes
Fuzzy grouping and lookup transformations	Yes
Term extractions and lookup transformations	Yes

Master Data Services

Note

• [!INCLUDEssMDSshort] is available on the 64-bit editions of Business Intelligence and Enterprise only.

Feature	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEssMDSshort] database	Yes	Yes
[!INCLUDEssMDSmdm] web application	Yes	Yes

Data Warehouse

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Create cubes without a database	Yes	Yes	Yes
Auto-generate staging and data warehouse schema	Yes	Yes	Yes
Change data capture	Yes
Star join query optimizations	Yes
Scalable read-only Analysis Services configuration	Yes
Parallel query processing on partitioned tables and indices	Yes
xVelocity memory optimized columnstore indexes	Yes
Global Batch Aggregation	Yes

Analysis Services

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Scalable Shared Databases (Attach/Detach, Read only databases)	Yes	Yes
Backup/Restore, Attach/Detach databases	Yes	Yes	Yes
Synchronize databases	Yes	Yes
High Availability	Yes	Yes	Yes
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL)	Yes	Yes	Yes

BI Semantic Model (Multidimensional)

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Semi-additive Measures	Yes	Yes	No1
Hierarchies	Yes	Yes	Yes
KPIs	Yes	Yes	Yes
Perspectives	Yes	Yes
Actions	Yes	Yes	Yes
Account intelligence	Yes	Yes	Yes
Time Intelligence	Yes	Yes	Yes
Custom rollups	Yes	Yes	Yes
Writeback cube	Yes	Yes	Yes
Writeback dimensions	Yes	Yes
Writeback cells	Yes	Yes	Yes
Drillthrough	Yes	Yes	Yes
Advanced hierarchy types (Parent-Child, Ragged Hiearchies)	Yes	Yes	Yes
Advanced dimensions (Reference dimensions, many-to-many dimensions	Yes	Yes	Yes
Linked measures and dimensions	Yes	Yes
Translations	Yes	Yes	Yes
Aggregations	Yes	Yes	Yes
Multiple Partitions	Yes	Yes	Yes, up to 3
Proactive Caching	Yes	Yes
Custom Assemblies (stored procs)	Yes	Yes	Yes
MDX queries and scripts	Yes	Yes	Yes
DAX queries	Yes	Yes
Role-based security model	Yes	Yes	Yes
Dimension and Cell-level Security	Yes	Yes	Yes
Scalable string storage	Yes	Yes	Yes
MOLAP, ROLAP, HOLAP storage modes	Yes	Yes	Yes
Binary and compressed XML transport	Yes	Yes	Yes
Push-mode processing	Yes	Yes
Direct Writeback	Yes	Yes
Measure Expressions	Yes	Yes

¹The LastChild semi-additive measure is supported in standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

BI Semantic Model (Tabular)

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Hierarchies	Yes	Yes
KPIs	Yes	Yes
Perspectives	Yes	Yes
Translations	Yes	Yes
DAX calculations, DAX queries, MDX queries	Yes	Yes
Row-level Security	Yes	Yes
Partitions	Yes	Yes
In-Memory and DirectQuery storage modes (Tabular only)	Yes	Yes

PowerPivot for SharePoint

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
SharePoint farm integration based on shared service architecture	Yes	Yes
Usage reporting	Yes	Yes
Health monitoring rules	Yes	Yes
PowerPivot Gallery	Yes	Yes
PowerPivot Data Refresh	Yes	Yes
PowerPivot Data Feeds	Yes	Yes

Data Mining

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Standard Algorithms	Yes	Yes	Yes
Data Mining Tools (Wizards, Editors Query Builders)	Yes	Yes	Yes
Cross Validation	Yes	Yes
Models on Filtered Subsets of Mining Structure Data	Yes	Yes
Time Series: Custom Blending Between ARTXP and ARIMA Methods	Yes	Yes
Time Series: Prediction with New Data	Yes	Yes
Unlimited Concurrent DM Queries	Yes	Yes
Advanced Configuration & Tuning Options for Data Mining Algorithms	Yes	Yes
Support for plug-in algorithms	Yes	Yes
Parallel Model Processing	Yes	Yes
Time Series: Cross-Series Prediction	Yes	Yes
Unlimited attributes for Association Rules	Yes	Yes
Sequence Prediction	Yes	Yes
Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression	Yes	Yes

Reporting Services

Reporting Services Features

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Supported catalog DB [!INCLUDEssNoVersion] edition	Standard or higher	Standard or higher	Standard or higher	Web	Express
Supported data source [!INCLUDEssNoVersion] edition	All [!INCLUDEssNoVersion] editions	All [!INCLUDEssNoVersion] editions	All [!INCLUDEssNoVersion] editions	Web	Express
Report server	Yes	Yes	Yes	Yes	Yes
Report Designer	Yes	Yes	Yes	Yes	Yes
Report Manager	Yes	Yes	Yes	Yes	Yes
Role based security	Yes	Yes	Yes	Yes	Yes
Word Export and Rich Text Support	Yes	Yes	Yes	Yes	Yes
Enhanced gauges and charting	Yes	Yes	Yes	Yes	Yes
Export to Excel, PDF, and Images	Yes	Yes	Yes	Yes	Yes
Custom authentication	Yes	Yes	Yes	Yes	Yes
Report as data feeds	Yes	Yes	Yes	Yes	Yes
Model support	Yes	Yes	Yes	Yes
Create custom roles for role-based security	Yes	Yes	Yes
Model Item security	Yes	Yes	Yes
Infinite click through	Yes	Yes	Yes
Shared component library	Yes	Yes	Yes
Email and file share subscriptions and scheduling	Yes	Yes	Yes
Report history, execution snapshots and caching	Yes	Yes	Yes
SharePoint Integration	Yes	Yes	Yes
Remote and non-SQL data source support1	Yes	Yes	Yes
Data source, delivery and rendering, RDCE extensibility	Yes	Yes	Yes
Data driven report subscription	Yes	Yes
Scale out deployment (Web farms)	Yes	Yes
Alerting2	Yes	Yes
[!INCLUDEssCrescent] 2	Yes	Yes

¹For more information on the supported datasources in [!INCLUDEssRSCurrent], see Data Sources Supported by Reporting Services (SSRS).

²Requires [!INCLUDEssRSnoversion] in SharePoint mode. For more information, see Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013).

Report Server Database Server Edition Requirements

When creating a report server database, not all editions of [!INCLUDEssNoVersion] can be used to host the database. The following table shows you which editions of the [!INCLUDEssDE] you can use for specific editions of [!INCLUDEssRSnoversion].

For this edition of [!INCLUDEssNoVersion] Reporting Services	Use this edition of the Database Engine instance to host the database
Enterprise	Standard, Business Intelligence Enterprise, editions (local or remote)
Business Intelligence	Standard, Business Intelligence Enterprise, editions (local or remote)
Standard	Standard, Enterprise editions (local or remote)
Web	Web edition (local only)
Express with Advanced Services	Express with Advanced Services (local only).
Evaluation	Evaluation

Business Intelligence Clients

The following software client applications are available on the Microsoft Downloads center and are provided to assist you with creating business intelligence documents that run on a [!INCLUDEssNoVersion] instance. When you host these documents in a server environment, use an edition of [!INCLUDEssNoVersion] that is supported for that document type. The following table identifies which [!INCLUDEssNoVersion] edition contains the server features required to host the documents created in these client applications.

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEssRBnoversion]	Yes	Yes	Yes
Data Mining Addins for Excel and Visio 2010	Yes	Yes	Yes
[!INCLUDEssGeminiClient] 2010	Yes	Yes
[!INCLUDEssMDSshort] [!INCLUDEssMDSXLS]	Yes	Yes

Note

1. [!INCLUDEssGeminiClient] is an Excel addin and does not depend on [!INCLUDEssNoVersion]. However [!INCLUDEssGeminiShort] is required for sharing and collaborating with [!INCLUDEssGemini] workbooks in SharePoint and this capability is available as part of [!INCLUDEssNoVersion] Enterprise and Business Intelligence editions.
2. The above table identifies the [!INCLUDEssNoVersion] editions that are required to enable these client tools; however these features can access data hosted on any edition of [!INCLUDEssNoVersion].

Spatial and Location Services

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Spatial indexes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Planar and Geodetic datatypes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Advanced spatial libraries	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Import/export of industry-standard spatial data formats	Yes	Yes	Yes	Yes	Yes	Yes	Yes

Additional Database Services

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
[!INCLUDEssNoVersion] Migration Assistant	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Database mail	Yes	Yes	Yes	Yes

Other Components

Feature Name	Enterprise	Business Intelligence	Standard	Web	Express with Advanced Services	Express with Tools	Express
Data Quality Services	Yes	Yes
StreamInsight	StreamInsight Premium Edition	StreamInsight Standard Edition	StreamInsight Standard Edition	StreamInsight Standard Edition
StreamInsight HA	StreamInsight Premium Edition

See Also

Product Specifications for SQL Server 2014
Installation for SQL Server 2014
Quick-Start Installation of SQL Server 2014