Post reply

Cache a table in memory?

  • January 20, 2004 at 6:44 am

    #85433

    Oracle has the capability to cache or "pin" a table in memory. This is a great tool for static lookup tables with high access rates. Is there any comparable feature or function in MS SQL?

    Inquiring minds want to know.... 

     

  • January 20, 2004 at 7:10 am

    #490807

    yes, there is.

    Take a look  at DBCC PINTABLE or sp_tableoption in BOL

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 20, 2004 at 7:20 am

    #490808

    Duh... I should have looked at BOL first!

    Thanks.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply