Home Forums SQL Server 2014 Development - SQL Server 2014 SET ANSI_NULLS OFF DILEMA RE: SET ANSI_NULLS OFF DILEMA
Prakash-205770
Ten Centuries
Points: 1079
More actions
August 3, 2015 at 4:54 am
#1816749
Hi,
You can create non-clustered (not unique) indexes, and can improve performance.
If you change the setting from ANSI NULLS OFF to ON, you need to do Regression Testing.
In my opinion, ANSI NULLS setting has to do nothing with Deadlocks..
R