http://sqlserver.ro/forums/38/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/412.aspxTue, 17 Oct 2006 08:15:13 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:412xmldeveloper0http://sqlserver.ro/forums/thread/412.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=38&PostID=412<p><strong>Source: <a href="http://blogs.msdn.com/cbiyikoglu/archive/2005/11/03/488920.aspx" id="bp___ctl00___RecentPosts___postlist___EntryItems_ctl02_PostTitle">Forced and Simple Parameterization in SQL Server 2005</a>&nbsp;(<a class="headermaintitle" href="http://blogs.msdn.com/cbiyikoglu/default.aspx" id="bp___ctl00___bth___BlogTitle"><font color="#000000">TSQLNet Weblog - Cihangir Biyikoglu</font></a>)</strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';"></span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">SELECT </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">c.[text],</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">a.refcounts,</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">a.usecounts,</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">d.query_plan </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">FROM sys.dm_exec_cached_plans a </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">OUTER APPLY sys.dm_exec_plan_attributes(a.plan_handle) b </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">OUTER APPLY sys.dm_exec_sql_text(CAST(b.VALUE AS VARBINARY)) c </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">OUTER APPLY sys.dm_exec_query_plan(a.plan_handle) d </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">WHERE b.attribute=&#39;sql_handle&#39; AND a.cacheobjtype = &#39;Compiled Plan&#39; </span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:'Courier New';">ORDER BY a.usecounts DESC</span></strong></p><p>&nbsp;</p><font face="Courier New"></font>