Tuesday, October 4, 2016

Main Limitations of SQL Server Express Editions

SQL Server Express Editions are a handy solution for small businesses with small databases with no special requirements about performance, high availability, encryption, etc.

However, the Express Editions of SQL Server, even free, as expected, have certain limitations. In the below table I have gathered some of these limitations which I can consider are the limitations someone might want to check as a first look. In the end of each column, there is a URL with more information about all the limitations of the express edition for each SQL Server version.

Main Limitations of SQL Server Express Editions (note: this is not the full limitations list)
Feature/SQL Server Version SQL Server 2005 Express SQL Server 2008 R2 Express SQL Server 2012 Express SQL Server 2014 Express SQL Server 2016 SP1 Express
Maximum number of CPU/Cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores
Maximum memory per instance 1 GB 1 GB 1 GB 1 GB 1 GB
Maximum database size 4 GB 10 GB 10 GB 10 GB 10 GB
In-memory OLTP N/A N/A N/A No Yes
Always Encrypted N/A N/A N/A N/A Yes
Row-Level Security N/A N/A N/A N/A Yes
Dynamic Data Masking N/A N/A N/A N/A Yes
Partitioning No No No No Yes
AlwaysOn Failover Cluster Instances No No No No No
Always On Availability Groups N/A N/A No No No
Transparent database encryption N/A No No No No
In-Memory Columnstore N/A N/A No No Yes
Polybase N/A N/A N/A N/A Yes
URL for more info/full limitations list Click Here Click Here Click Here Click Here Click Here
For more articles please check: The SQL Server and .NET Blog Article by Artemakis Artemiou, Microsoft Data Platform MVP

The SQL Server and .NET Hub

Reference: The SQL Server and .NET Hub (http://www.sqlnethub.com)

*Note: The above table does not contain all limitations of SQL Server express editions. For the full lists of limitations, click on the URL provided in the end of each column for every SQL Server version.

Last Updated: Nov 19 2016

Check out my latest eBook on SQL Server:
Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (http://www.sqlnethub.com)