Markus (1/20/2010)
Couldn't one just 'pin' the tables in the specific database and that would hold them in memory? I have never done this but I have heard of it.
No. DBCC PinTable is a No-operation in SQL 2005/2008. The command's there, it does nothing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability