Post reply

stored procedure running slower than sql query

  • March 1, 2012 at 5:23 am

    #1453558

    Thanks Chris, I had a same issue. It is resolved with your solution.

    Regards,
    Nitin

  • May 9, 2012 at 7:56 am

    #1485060

    This worked for me. Thanks!

    One thing I thought was interesting though was that I had the same exact parameter names (@START_DATE, @END_DATE). Could these be some kind of pseudo-keywords tripping things up in the optimizer?

    - Peter

  • November 3, 2016 at 1:35 pm

    #1910463

    This worked for me!

    Added OPTION(Recompile) at the end of query in stored procedure.

    Thanks

    Vishwanath

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply