Post reply

Parameter Sniffing with sp_ExecuteSQL ?

  • October 7, 2008 at 11:28 pm

    #882108

    Did you find the time to tset my suggestion, ie run the query manually vs the vendor-provided query?

    Was there a time difference? Was the plan different?

    I believe the query will run faster than 900 second.

    N 56°04'39.16"
    E 12°55'05.25"

  • October 8, 2008 at 11:31 am

    #882473

    Peso (10/7/2008)

    Did you find the time to tset my suggestion, ie run the query manually vs the vendor-provided query?

    Was there a time difference? Was the plan different?

    I believe the query will run faster than 900 second.

    Sorry, Peter, I finished on Friday evening and I think that you suggested code change was posted on Monday.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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