Howtos / Articles

Microsoft SQL Server 2008 R2 Express Limitations

Microsoft SQL Server 2008 R2 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2008 R2 Express Edition. CPU: 1 CPU (based on a socket). No limit on cores. Memory: Maximum of 1GB for the database engine. (Note: SQL 2008 R2 Express Edition with Advanced Services includes reporting features, and has a limit of 4GB for…

Read more [...]