The RECOMPILE Options

  • Grubb (7/7/2011)


    Thanks for the links, Steve!

    As an aside, Gail is teaching an entire class on Execution Plans at this year's PASS conference: http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1245

    Minor correction. Grant and I are teaching that together. Should be awesome fun.

    See you there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Oddly enough, I have a stored proc that is called by Excel through ADO however Excel will crash everytime giving a generic error UNLESS I have the WITH RECOMPILE clause in my stored procedure.

  • GilaMonster (7/10/2011)


    Minor correction. Grant and I are teaching that together. Should be awesome fun.

    See you there.

    It's gonna be awesome!

    Gail, what is your Avatar a picture of?

    -Grubb

  • Grubb (7/12/2011)Gail, what is your Avatar a picture of?

    Marcus Cole. Character on Babylon 5. Same place my sig quote is from.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 31 through 33 (of 33 total)

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