Have any of you had a chance to try out some of the stuff Adam Machanic did with Inline TVF's? Just curious, becuase the perf differences are fairly remarkable.

I still don't think it gets past all of the circumstances, and I also suspect it's a preciously narrow window where this would be as good or better, but still, interesting read nonetheless....

Here's the blog post I had in mind.

http://sqlblog.com/blogs/adam_machanic/archive/2006/08/04/scalar-functions-inlining-and-performance-an-entertaining-title-for-a-boring-post.aspx

I adapted this to a 10M row test, and the inline BEAT the "straight" group by scenario.