stored procedure question

  • hi guys i have a question, I have a stored procedure which takes 45 seconds to run when i do an EXEC but when i run it manually with parameters it runs in 3 seconds, any ideas why this might happen?

  • Look up "parameter sniffing" online. This site and others will have a lot of data on what is probably happening.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

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