Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Huge difference in query time when changing date range a few months. Code/exc plans included RE: Huge difference in query time when changing date range a few months. Code/exc plans included

  • October 11, 2014 at 1:34 pm

    #1751832

    Okay, I removed the CTE that was being used for Immune denom and set it to a regular query update and now it ran in 24 seconds.. So confused.:w00t:

    ***SQL born on date Spring 2013:-)