Optimizing Stored Procedures that utilize only local variables (and lots of them)

  • Blah, what haven't you written?

    Apparently I've had too many bad things taught to me.

    I could swear that I've had performance differences between them, but that would have been at least one employer and 2-3 titles/positions ago. I don't even want to pull out a SQL Server 2000 install to setup some kind of test case to even see if my memory is correct or not. 🙂

    Didn't see them in the first link you sent. But thanks...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing post 16 (of 17 total)

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