• It won't be due to multiple executions of getdate. The function is fast, but besides that it will only be evaluated once in the query execution (otherwise you'd get multiple different dates in a long-running query, which you don;'t).

    Now that you mention it, the query plans do look similar and there are no index scans in either, so I suspect you are correct.

    And yes it is variables, not parameters.

    I've attached the query plans for both.