What are the limitations of SQL Server 2008 Express?

Question

How is this product limited in comparison to the other SKUs?

Answer 1

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

Answer 2

Per the product info page (toward the bottom):

SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage

Answer 3

Is the 4 GB limit (which in R2's case has been increased to 10 GB), implies to total storage or per database?