Caching Tables

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Take a look at DBCC PINTABLE in BOL

Frank

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

Bernd.Bast SSC Veteran Points: 202 More actions · Answer 2

That's it. Thanx for the ultraquick answer.

Bernd.

quote:
Take a look at DBCC PINTABLE in BOL
Frank
http://www.insidesql.de
http://www.familienzirkus.de

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Von Hilden nach Köln ist es ja auch keine Entfernung.

Frank

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

Antares686 SSC Guru Points: 125444 More actions · Answer 4

Just be carefull not to overload your memory and be aware you will face a good deal of performance issues if you put too much in memory.