Mike Coles has posted a follow-up article "NULL Vs NULL" to his previous article "Four Rules On Nulls"
I noticed that SET ANSI_NULLS is been deprecated and will be removed in future versions only when I read this article. Now I have started looking for other deprecated features in SQL 2005. How I see that MS has not documented alternatives for SET ANSI_NULLS and few opther deprectaed features. Check Deprecated Database Engine Features in SQL Server 2005 for more details.