(Analysis Services, Reporting Services) 1 or 16 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 Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A Maximum memory utilized (per instance of Reporting Services) 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
Feature Name Business Web Express with Services with Tools 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) only Witness only Witness only Witness only AlwaysOn Failover Cluster Instances Yes (Node support: Operating system maximum Yes (Node support: 2) Yes (Node support: 2) Backup Yes Yes Yes Database snapshot Yes AlwaysOn Availability Groups Yes 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 Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Express support 50 50 50 50 50 50 50 and index partitioning Yes Data compression Yes Resource Governor Yes
Partition Table Parallelism Yes Multiple Filestream containers Yes 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 Yes Yes Yes Yes Yes Yes Yes Contained Databases Yes Yes Yes Yes Yes Yes Yes
Feature Name Business Web Express with Services Express with Tools Express SQL Server change tracking Yes Yes Yes Yes Yes Yes Yes Merge replication Yes Yes Yes Yes only) Yes only) Yes only) Yes only) replication Yes Yes Yes Yes only) Yes only) Yes only) Yes only) Snapshot replication Yes Yes Yes Yes only Yes only) Yes only) Yes only) subscribers Yes Yes Yes Oracle publishing Yes Peer to Peer replication Yes Feature Name Business Web Express with with Tools
Services SQL Management Objects (SMO) Yes Yes Yes Yes Yes Yes Yes SQL 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 Yes Yes Distributed Replay – Admin Tool Yes Yes Yes Yes Yes Yes Distributed Replay - Client Yes No Yes Yes Distributed Replay - Controller Yes supports up to 16 clients, Developer supports only 1 client) No Yes (1 client support only) Yes (1 client only) SQL Profiler Yes Yes Yes No2 No2 No2 No2 SQL Server Agent Yes Yes Yes Yes
Automatic indexed view Yes Yes Yes Yes Distributed partitioned views Yes Partial. Views are not updatable Partial. Views are not Partial. Views are not Partial. Views are not Partial. Views are not Partial. Views are not Parallel indexed operations Yes Automatic use of indexed view by query optimizer Yes Parallel consistency check Yes SQL Server Utility control point Yes Contained Databases Yes Yes Yes Yes Yes Yes Yes Partition
Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Express Microsoft Visual Studio Integration Yes Yes Yes Yes Yes Yes Yes Intellisense and MDX) Yes Yes Yes Yes Yes Yes Yes SQL Server Data Tools (SSDT) Yes Yes Yes Yes Yes SQL query edit and design tools1 Yes Yes Yes Version control support1 Yes Yes Yes MDX edit, and design tools1 Yes Yes Yes 1 This feature is not available for 64-bit version of Standard edition. Feature Name Business Web Express with with Tools
Services 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 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 only) No (Client only) No (Client only) No (Client only) Web services (HTTP/SOAP endpoints) Yes Yes Yes Yes
TSQL endpoints Yes Yes Yes Yes Feature Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express SQL Server 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 Transforms Yes Yes Yes Basic data profiling tools Yes Yes Yes Change Data Capture Service for Oracle by Attunity Yes Change Data Capture Designer Yes
for Oracle by Attunity 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 processing destination adapter Yes Change Data Capture Yes
Note Master Data Services 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 Master Data Services database Yes Yes Master Data Manager web application Yes Yes Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express Create cubes without a database Yes Yes Yes staging and Yes Yes Yes
data warehouse schema 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 Feature Name Business Express with Services with Tools Scalable Shared Databases Yes Yes
(Attach/Detach, Read only databases) Attach/Detach databases Yes Yes Yes Synchronize databases Yes Yes High Availability Yes Yes Yes (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 Measures Yes Yes No1 Hierarchies Yes Yes Yes KPIs Yes Yes Yes Perspectives Yes Yes Actions Yes Yes Yes Account intelligence Yes Yes Yes
Proactive Caching Yes Yes Custom Assemblies (stored procs) Yes Yes Yes MDX queries and scripts Yes Yes Yes Role-based security model Yes Yes Yes Dimension and Security Yes Yes Yes Scalable string storage Yes Yes Yes ROLAP, HOLAP storage modes Yes Yes Yes Binary and compressed XML transport Yes Yes Yes Push-mode processing Yes Yes Measure Expressions Yes Yes
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 DAX calculations, DAX queries, MDX queries Yes Yes 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 Express SharePoint farm Yes Yes
Report Designer Yes Yes Yes Yes Yes Report Manager Yes Yes Yes Yes Yes Role 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 PDF, Images, and Atom compliant data feeds Yes Yes Yes Yes Yes Client-side printing using the RSClientPrint control. Yes Yes Yes Yes Yes Rendering to interactive HTML. Yes Yes Yes Yes Yes Custom Yes Yes Yes Yes Yes Report as data feeds Yes Yes Yes Yes Yes Model support Yes Yes Yes Yes
Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express SQL Server Migration Assistant Yes Yes Yes Yes Yes Yes Yes Database mail Yes Yes Yes Yes Feature Name Enterprise Business Standard Web Express with with Tools Data Quality Services Yes Yes Premium Edition Standard Edition Standard Edition Standard Edition HA Premium Edition SQL Server 2014 New Features:
SQL Server 2000 codename Shiloh 8.0.194 SQL Server 7.0 codename Sphinx 7.0.623 ------------------------------------------------------------------------------------