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)
  • 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
  • SQL Sentry is sponsoring a new blog :

    This week, SQL Sentry has launched a new performance-related SQL Server blog: I'm very excited about this new project, and I'm looking forward to some good information flow in both directions. The goal is to present new and interesting solutions to some common problems, and to explore both old and new SQL Server features from ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 25, 2012
Privacy Statement