How is this product limited in comparison to the other SKUs?
3 Answers
Check out SQL Server Editions page at Microsoft. Also this Feature Comparison Chart at Microsoft.
Essentially:
- 1 CPU
- 4Gb maximum database size
- Unlimited users
- No SQL Server Agent support
- Still has support for procedures, triggers & functions
- Need Management Studio Express or Higher to manage the instance
Per the product info page (toward the bottom):
SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage
Is the 4 GB limit (which in R2's case has been increased to 10 GB), implies to total storage or per database?
-
1