1. SQL Server 2012 Express editions are
limited to the lesser of one socket or four cores.
2. The maximum memory for the database
engine is limited to 1GB and the maximum relational database size is 10GB.
3. Although SQL Server Express is
limited in scalability, a common misconception is that it’s limited to a single
database or 10 connections.
4. SQL Server Express can support
multiple databases where each database can be up to 10GB
5. SQL Server 2012 Express has no
limits on incoming connections or workload other than the CPU and memory
limitations. And it comes in both 32-bit and 64-bit versions.
6. SQL Server Express (Database
Only)
a.
The
basic offering of SQL Server 2012 Express, SQL Server Express (Database Only)
edition includes only the relational database engine.
Many GFI Products can make use of SQL Express
databases. However, it is important to note that these databases have strict
size limits, which may inhibit the amount of data that a GFI application can
store in them. These limits are as follows:
- Microsoft SQL Server 2005 Express edition has a database size limit to 4GB
- Microsoft SQL Server 2008 Express edition has a database size limit to 4GB
- Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB
- Microsoft SQL Server 2012 Express edition has a database size limit to 10GB
- Microsoft SQL Server 2014 Express edition has a database size limit to 10GB