While going through ‘Microsoft SQL Server 2005 for dummies’, it was a bit confusing for me to read that SQL Server 2005 express edition is capable of utilizing just 1GB of RAM. I have snapped the view from pdf version of the book.
After little Googling it is confirmed in BOL that SQL server 2005 express edition has no limit for maximum RAM. It would use as much as RAM available by OS.
So here ‘SQL Server 2005 for dummies’ have created some confusion by mentioning the limitation in their table 1-3. Also i confirmed BOL statement by right clicking on express instance in SSMS. And it showed as much RAM as available by OS. Let me also clarify that mentioned limit of 3GB RAM for workgroup edition is also not right. It also carries maximum RAM available by OS.