1

2

4

No Limit

Includes support for multicore processors.

1 gigabyte (GB)

3 GB

Operating system maximum

Operating system maximum

Memory limited to maximum supported by operating system.

Windows on Windows (WOW)

WOW

4 GB

No Limit

No Limit

No Limit

Support for large-scale databases

Parallel processing of indexing operations

Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition.

¹

Advanced high availability solution that includes fast failover and automatic client redirection

²

Data backup and recovery solution

Includes Hot Add Memory, dedicated administrative connection, and other online operations

Database available when undo operations begin

Automatically tunes database for optimal performance.

¹

²

See Comments

Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download

Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio.

Automatically suggests enhancements to your database architecture to improve performance.

Dynamic management views and reporting enhancements.

See comments

Available for SQL Server Express in the SQL Server Express w/ Advanced Services download

Built-in data encryption for advanced data security.

Scans your system to check for common security vulnerabilities.

Includes exception handing, recursive queries, and support for new data types.

Extend the server with your own custom data types.

Includes XML indexing and full-text XML search.

Allows the building of advanced subscription and publication applications.

See comments

SQL Server Express can exchange messages with other editions. Messages between instances of SQL Server Express must be routed through another edition.

Provides graphical extract, transform, and load (ETL) capabilities.

Includes data mining, text mining, and data cleansing.

¹

²

³

⁴

Transactional replication with an Oracle database as a publisher

Support for native Web services, Web Services Description Language (WSDL), and Web authentication

See Comments

Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download.

End-user reporting tool

¹

See Comments

²

³

Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.

Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore.

⁴

⁵

Allows access to data from any device.

Powerful analytics and data mining capabilities.

Enterprise business data model enables fast, interactive, ad hoc analysis of large data sets. Builds smarter reports that leverage centralized business logic and key performance indicators (KPIs), as well as the performance of UDM.

Multidimensional Expression (MDX) scripts and MDX debugger, .NET stored procedures, Time Intelligence, KPI Framework.

Account intelligence, metadata translation, perspective and semi-additive measures.

Provides automated caching for greater scalability and performance.

Partitioned cubes, parallel processing, server synchronization.

Dimension and cell writeback

Nine algorithms including decision and regression trees, clustering, logistic and linear regression, neural networks, naive bayes, association, sequence clustering, and time series. Build smarter reports that leverage centralized business logic and KPIs, as well as the performance of UDM.

Additional options for tuning data mining models for the highest accuracy, performance, and scalability.

Perform data mining prediction and training operations directly in your operational data pipelines.

Convert unstructured text data to structured data for analysis via reporting, online analytical processing (OLAP), or data mining.