SQL Server uses a lot of memory
Here's a little work around for SQL server which uses a lot more memory than it should. Naturally, you can set this through the properties of the instance it self. however, since this is a bug in microsoft sql server 2008 (r2?), this script is a workaround.