Home Forums SQL Server 2014 Development - SQL Server 2014 Is there a reason for the ISO behaviour of ANSI_NULL? RE: Is there a reason for the ISO behaviour of ANSI_NULL?

  • July 7, 2015 at 5:51 am

    #1810674

    Hi,

    Casually I heard just the opposite yesterday. SQL Server query engine uses additional resources to detect the use of NULLs while ANSI_NULL is set to OFF

    Here is a good example

    http://sqltouch.blogspot.ie/2013/05/ansinulls-joinwhere-and-query-optimizer.html

    Indeed the option of using NULLs like other value will be discontinued in future versions

    SET ANSI_NULL

    https://msdn.microsoft.com/en-us/library/ms188048.aspx