I have a question about dbcc unpintable
if you unpin a table, it will stay in cache until sql server flushes the cache.
1. how can you force a cache flush
2. can this be done programmatically? (ergo: not shutting services down)
2. can you force a partial flush (dictate, what is or isnt flushed)
"dbcc dropcleanbuffers" by itself would do just that, - drop unused buffers from the data cache. those buffers contain any data loaded by read-ahead process, as well as data resulted from pinning a table. if you preceed this statement with checkpoint all dirty buffers would be flushed to disk and flagged as clean.