An Architect's vision

Any use of the Oracle Database Express Edition is subject to the following limitations; 1. Express Edition is limited to a single instance on any server; 2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server; 3. Express Edition may only be used to support up to 11GB of user data (not including Express Edition system data); 4. Express Edition may use up to 1 GB RAM of available memory.

1. SQL Server Express uses only one CPU at a time. It can be installed on a server with multiple CPUs, but it will use only one CPU at a time. 2. SQL Server Express uses a maximum of 1 GB memory for it's data buffer. So, if your server has several GB memory, SQL Server Express cannot take advantage of it. 3. Maximum database size is limited to 4 GB per database (10 GB for SQL Server Express 2008 R2 and above) 4. Profiler tool is not included with SQL Server Express editions. 5. No SQL Server Agent service 6. Job Scheduling service is not available with SQL Server Express. 7. Data import and export feature is not available with SQL Server Express.