Adam Machanic : exec, DMVshttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/exec/DMVs/default.aspxTags: exec, DMVsenCommunityServer 2.1 SP2 (Build: 61129.1)The Hidden Costs of INSERT EXEChttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/06/25/the-hidden-costs-of-insert-exec.aspxThu, 25 Jun 2009 20:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:14921Adam Machanic17http://www2.sqlblog.com/blogs/adam_machanic/comments/14921.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=14921INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/06/25/the-hidden-costs-of-insert-exec.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=14921" width="1" height="1">PerformanceDMVsinsertexec