I have a query like this:
SELECT col1 FROM MyTable WHERE DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) BETWEEN col2 AND col3 ;
This gives a tooltip on the execution plan similar to this:
dateadd part of the seek predicates get executed for every row in the query? Or does SQL Server calculate the value once for the whole query?