Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days.

I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this reason: the more people have learned about parameter sniffing, the more popular DBCC FREEPROCCACHE() becomes. Grant’s post explains how not to throw out the baby with the bathwater.

Happy days,
Jen McCown
http://www.MidnightDBA.com/Jen