http://sqlblog.com/blogs/uri_dimant/archive/2010/03/04/another-bad-habit-to-kick-checking-variables-in-dml-operations-not-just-before.aspxPerhaps I am 'breaking in' Aaron's bad habits series of blogs or Alex's defensive programming but I would like to share with you the style I have seen recently on the client's side and how it affects perfromance. There is long lines stored procedure thatenCommunityServer 2.1 SP2 (Build: 61129.1)