Cache a table in memory?
-
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....
-
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] -
Duh... I should have looked at BOL first!
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply