Performance Surprises and Assumptions : DATEADD

I explore yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.