I've heard MSSQLMS SQL Server takes up as much ramRAM as it can to cache results. Well, it's not leaving enough bargaining room for our little server's RAM.
How do I change the settings to limit the amount of RAM it can use?
MSSqlServerMS SQL Server running on Windows Server 2008.