Please look for following topics:

http://msdn.microsoft.com/en-us/library/ms189631.aspx

http://msdn.microsoft.com/en-us/library/ms188787.aspx

and related.

You can use the stored procedure sp_configure to define how your MS SQL server should use memory.

You can set the...