Pinning a table/index to memory

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  May 24, 2003 at 11:06 am

  #175734

  Hi there, in Oracle there was a way to pin an object in memory so it would stay there. Is there a way in SQL 7/2000 to do this? Thanks in advance.

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  May 24, 2003 at 1:00 pm

  #458448

  DBCC Pintable.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn