http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/02/20/inline-udfs-do-not-prevent-parallel-execution-plans.aspxLots of things can prevent parallel execution plans, but inline UDFs are not one of them. Inline UDFs are essentially macros - they are at least as fast as CTEs. As such, the optimizer can produce exactly the same parallel execution plans whether if ourenCommunityServer 2.1 SP2 (Build: 61129.1)