SQL Server memory limit solution

SQL Server express editions have memory limit of 1GB. Can I install multiple versions of SQL Servers say SQL Server 2005 and SQL Server 2008, both express editions on same 开发者_运维问答machine and expect that both will use 1GB memory limit separately. Is it true? I have two DBs and I can attach one to 2005 edition and other to 2008 edition. Any suggestion please. Will it work or not?

---

Yes.

A SQL Server install is called an "instance", which allows you to have multiple instances various versions (including the same one).

My recommendation would be that if you aren't using an instance, that it not be turned on or it'll be reserving memory that could be used for other things.