Our Company has several SQL Server Enviornments, some of them work with MS-SQL Server 2005 Express Edition others with Standard or Enterprise Edition.
In a discussion today a DBA said MSSQL Express Ed. would be less performant then the Standard Edition.
Well I know there are the following limits:
Server does use only 1GB of memory
Server does use only 1 CPU
but I don't know that there are other limitations. What is your experience there are other possible performance problems?
Best Answer
One correction to the previous answers - SQL Server Express supports a single CPU socket only - but if the socket has multiple cores, Express will use them and you'll get parallelism. Little known fact...