plan caching in sql 2005
I have not posted for almost 2 weeks. I have been very busy with Yukon work.
Today this paper come to my attention, I think it is very useful for anyone who are interested in performance tuning in SQL 2005.
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx