Performance Surprises and Assumptions : DATEADD Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly. Aaron Bertrand ◆ April 11, 2016 12