On the download page, you may have noticed that there are two versions of SQL Server Express
- SQL Server 2008 Express
- SQL Server 2008 Express with Advanced Services
While the SQL Server 2008 Editions page doesn’t list the "Advanced Services" Express Edition, luckily Mike Wachal from the SQL Server Express team posted a detailed breakdown of the differences on the SQL Server Express blog.
The key features that are in Advanced Services that you won’t get with regular Express are:
- PowerShell integration by default
- Synchronization Services installed by default
As well as a number of Reporting Services features
- Ability to increase Reporting Services Memory Limit
- Reporting Services Word/Rich Text Export
- IIS Agnostic Report Deployment
- Enhanced Gauges and Charting
It also appears that the regular SQL Server Express also supports installing the 32-bit version on a x64 platform (using WoW), but as both Express versions including 32-bit and 64-bit native installations, I’m not sure why you would want to install the 32-bit version on x64.
What hasn’t changed
The physical limitations for SQL Server haven’t changed between 2005 and 2008 (1 CPU, 1GB Memory, 4GB of user data per database), but the nice thing is that SQL Server Express will take advantage of multiple cores on a single CPU.