Lempster (9/10/2014)
polkadot (9/5/2014)
Grant, thanks for feedback on second part of question. I dug around for more info and found I can find a query's plan handle and remove it with EBCC PREEPROCCACHE so that I start afresh when looking to see if optimization efforts changed....or to demonstrate how linked server aliased queries take longer.I'd advise against running DBCC FREEPROCCACHE (or even EBCC FREEPROCCACHE ;-)) against a Production database!
Regards
Lempster
But you can pass the plan handle to FREEPROCCACHE to remove a single plan. That's a fine thing to do in production, especially when dealing with a bad parameter sniffing issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning