SQL Server Standard 'Lock pages in memory' workaround coming soon...
Bob Ward just announced at European SQL PASS that you'll be able to use the 'lock pages in memory' workaround in SQL Server Standard Edition to resolve working set trimming issues.
In the next CU releases for SQL Server 2005 and 2008 you'll be able to enable it with a trace flag. Up to now its only been available on Enterprise Edition much to the chagrin of Standard Edition customers so I'm sure it'll be a popular move!
He's just promised to try and blog on it this afternoon.
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
http://coeo.com - SQL Server Consultants & Remote DBA Services