title: Year(Getdate()) taking 30 times longer to execute on SSRS starting Jan 1st, 2016
body: <p>I have an SSRS report that has been running for years.  As of 1/1/2016 one part of the report is taking over 30 times longer to execute.  It turned out to be the use of the <code>Year(Getdate())</code> function in the where clause of the query.  Changed it to a declared variable <code>@CurrYear int = Year(Getdate())</code> and then used <code>@CurrYear</code> in the where clause and it is back down to less than a second.  Why would this stop working on 1/1/2016 when it had been working for years?  Just curious if anyone else has seen this behaviour.</p>
  
  <p>Also, the queries run fine from management studio, the delay only happens on the report server.</p>