If you are using SQL Sever Server standard edition 64 bit on a Windows 2003 64bit, you will frequently encounter this problem where SQL Server says: A significant part of sql server process memory has been paged out. This may result in performance degradation...