I’ve been using MS SQL Server 2008 Express edition (x64) on Vista Ultimate SP2 quite a lot the last month and was running out of memory almost every day (the SQL Engine using +1GB of Memory!!)
Today I updated my SQL Instance to SQL Server 2008 Service Pack 1 and now it only uses between 100-150MB of memory .. So it seems that there might be a memory leak in the “prior SP1 version”
Download SQL Server 2008 Service Pack 1