Add a note about how CASE expressions and COALESCE() do not always short-circuit. And that there should not be an expectation of short-circuiting.

[AnyhowStep]

https://sqlperformance.com/2014/06/t-sql-queries/dirty-secrets-of-the-case-expression