SOLVED: What Are The Limits of SQL Express 2016 and Can SQL Express Be Used In Production?

It is a common misconception that SQL Express 2016 cannot or should not be used in production environments.  SQL Express 2016 (and SQL Express 2014 and 2012 and…) are most certainly licenced to be used in production at no cost.  In fact, for most small and medium applications the only significant difference between SQL Standard and SQL Express are performance and backup.

SQL Server Standard provides a very high level of performance that many applications will not need.  Often the end user cannot tell the difference between SQL Express and SQL Standard performance because humans cannot detect results returned in .005 seconds from SQL Standard appear vs .05 seconds from SQL Server Express.

Below is a nearly complete list of features in SQL Server Express and SQL Server Standard in decreasing order of importance (for most small and medium applications)

.

To confirm these numbers you can wade through Microsofts own SQL Server Comparison charts HERE and HERE .