Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Size Limit for Pinning a table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-18 : 09:35:34
Sunny writes "Hi,

I have read about pinning the frequently accessed tables into memory rather than let them accessed from the disk all the times. But what i wish to know is - Is there any cutoff limit for the size of a table that could make it a bad candidate for pinning?

Any help would be appreciated.

Thanks.
Sunny"
   

- Advertisement -