Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
