My database is read only and it is 1GB of size. I got 4GB of RAM (Windows Advanced Server 2000) and /3GB switch is enabled.
I would like to load all my tables into memory and keep them there.
How do I do that?
Thank You.

Sounds like a RDBMS question, you might be on the wrong forum.

But this might be what you are looking for "DBCC PINTABLE":
http://msdn.microsoft.com/library/de..._dbcc_30it.asp
But you still need to read the pages into the buffer cache (memory) and heed
this warning:


Caution Although DBCC PINTABLE can provide performance improvements, it
must be used with care. If a large table is pinned, it can start using a
large portion of the buffer cache and not leave enough cache to service the
other tables in the system adequately. If a table larger than the buffer
cache is pinned, it can fill the entire buffer cache. A member of the
sysadmin fixed server role must shut down SQL Server, restart SQL Server,
and then unpin the table. Pinning too many tables can cause the same
problems as pinning a table larger than the buffer cache.

--Douglas McDowell

"joelm" <joelm (AT) discussions (DOT) microsoft.com> wrote

use DBCC PINTABLE
Syntax
DBCC PINTABLE ( database_id , table_id )

Arguments
database_id

Is the database identification (ID) number of the table
to be pinned. To determine the database ID, use the DB_ID
function.

table_id

Is the object identification number of the table to be
pinned. To determine the table ID, use the OBJECT_ID
function.

Abhinav Kumar
akumar (AT) itmag (DOT) com.au


is enabled.