SQL Server 2005 Memory Management

Hi all,

I needed to load some tables in memory on startup because of performance reasons.
I'm using "select * from <table>", but there are few questions:

1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005)

2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?)

3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks)



Thanks in advance:

Siol En