Post reply

Can using a scalar UDF actually improve performance?

  • May 9, 2019 at 10:50 am

    #3638927

    Jeff Moden wrote:

    p.s.  I'm not 100% sure but I don't believe they've disabled the ability to turn ANSI NULLs off yet in 2017.  It has been an advisory for many years, though.  I still recommend that everyone get out of the habit of using WHERE SomeColumn = NULL and WHERE SomeColumn <> NULL or doing virtually any other direct relational comparison to NULL.

    + INFINITY!!!!

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply