THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql performance   (RSS)
Sorry, but there are no more tags available to filter with.
  • Inline UDFs do not prevent parallel execution plans

    Lots 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 our queries are wrapped in inline UDFs or copied and pasted into the main query. As usual, I will ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on February 20, 2013
Privacy Statement