Very interesting article!

Something important to remember though about COALESCE is that it will return out the data type of the expression with the highest data type precedence. This isn't functionally the same as an ISNULL, and if developers who don't have a good handle on data type precedence, you may end up with T-SQL with unexpected results.