Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.
Paul White (@SQL_Kiwi) continues his discussion about optimization and how recognizing transformations can help you make better decisions about potential query re-writes.