Home Forums Article Discussions Article Discussions by Author Discuss content posted by Simon Liew How efficient is your covered index? RE: How efficient is your covered index?

  • August 12, 2013 at 5:31 pm

    #1640740

    gfey (8/12/2013)

    Hi,

    ... On the other hand the resultset of first solution depends on the option ANSI_NULLS. If the option is set to ON the query returns only rows where carriertrackingnumber is null, otherwise it returns an empty resultset. ..

    Regargs

    Gregor

    Hi Gregor,

    Thanks for your comment.

    Microsoft has announced ANSI_NULLS deprecation in SQL 2012. ANSI_NULLS OFF will not be supported in future version of SQL. Hence, I haven’t evaluated this as an option.

    Simon Liew
    Microsoft Certified Master: SQL Server 2008