So what's the correct method ? ANSI_NULLS should be ON or OFF ? By default I set it to ON on all distributed queries and when creating store procedures and manipulating indexes.

SET ANSI_NULLS ON

i is null

i 0

i = 0

SET ANSI_NULLS OFF

i is null

i 0

i 0