Forcing an entire DB into ram

We've got a database server with lots of spare RAM, is it possible to force MS SQL to load an entire database into RAM, to aid performance, we're looking at doing this to solve a performance issue in the short term to give us enough time to re-visit and fix the code.
thanks
mike

As you have enough RAM , if you want to keep your data in the bufferpool for long time you should:

• Set min server memory = max server memory
• Lock pages in memory using the group policy (for Enterprise Edition)

Any select statement is cached in bufferpool

if you have enough RAM1. I hope you are using Enterprise or 64bit version of Standard to use unlimited memory; and actual database data size is lesser then server RAM.2. set the 'max server memory' for SQL to use all memory minus -2GB for OS.3. read all tables data once, during non-production working hours; this will bring data pages from disk to memory4. keep checking 'page life expectancy' and 'buffer cache hit ratio'. During query processing..you will be having all data read from cache; not exactly similar to pintable but worth using memory.BTW, what are the server configurations, in term of resources??