I'm curious to know if the 'ON' predicate will behave the same as the 'WHERE' statement in all cases described in the article?

If you convert your @varDate local to a smalldatetime local before using it in the SELECT statement you can do a straight comparison of the local variable and the table...