Disabling cache

One of the tables in my DB has a BLOB field that retrieved quite rare, so I
do not really need to have it in cache and would prefer to keep in the RAM
cache more useful data instead. Is it possible to disable caching of BLOB
values?
Message posted via http://www.droptable.com
Hi
There is no way to turn it off, but since it is rarely used, it will fall
out the cache very quickly as SQL Server is very good at tuning it's cache.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alex via droptable.com" <no@.spam.pls> wrote in message
news:58af54c993dcc@.uwe...
> One of the tables in my DB has a BLOB field that retrieved quite rare, so
> I
> do not really need to have it in cache and would prefer to keep in the RAM
> cache more useful data instead. Is it possible to disable caching of BLOB
> values?
> --
> Message posted via http://www.droptable.com