Exactly. That's why I was concerned when the development team asked me whether it would be okay to set ANSI_WARNINGS to OFF.

I knew that doing so generates bad data and impacts system behaviour (no errors when you expect it to error out, etc) - which is the key point of this article.

"My immediate reaction was to understand why the team was trying to set ANSI_WARNINGS to OFF because setting ANSI_WARNINGS to OFF can have an impact on the data quality and system behaviour. This article demonstrates how setting ANSI_WARNINGS of OFF impacts system behaviour."