• Greg.Gum (8/12/2008)[Snip]

    CLR Recursion SQL Server Execution Times:

    CPU time = 0 ms, elapsed time = 5 ms.

    any chance of querying the cost column in the sys.dm_clr_appdomains

    before and after the clr task ?

    As It doesn't aggregate into statistics time CPU.

    I have trouble believing that interpreting MSIL and recursion could be less effort than a pre bounded CTE with no virtual method calls.

    see http://msdn.microsoft.com/en-us/library/ms187720.aspx