SQLServerCentral.com Scripts tagged plan cachehttp://www.sqlservercentral.com/Scripts tagged plan cache posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Find Single use plans in Plan CacheThis script will return all the Adhoc Single use Plans currently in your Plan Cache. It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008

]]>http://www.sqlservercentral.com/scripts/plan+cache/95251/Tue, 11 Dec 2012 07:00:00 UThttp://www.sqlservercentral.com/scripts/plan+cache/95251/