disable caching

hi,

just need help to find a way to disable caching.

well let's say I'm runniung a Select command on a big table.

the first time it is running you can see the real time that server takes to deliver the results. but if you run it again it will use the catch and the responce is almost without any delay.


is there any setting that I can disable caching( temp.) for a test I'm doing


many thanks

Ciao

S

You can't disable caching but you can clear the cache after first run using

dbcc dropcleanbuffer

command. It works in SQL 2K only.

thanks