Home Forums SQL Server 2008 SQL Server 2008 - General sp_executesql within SP Acting as Ad-Hoc Query RE: sp_executesql within SP Acting as Ad-Hoc Query

  • November 25, 2014 at 9:17 pm

    #1760958

    JoshDBGuy (11/25/2014)

    All,

    We have dozens of stored procs with sp_executesql inside the procs. When I run an analysis to determine long-running queries, these are acting as if they are ad-hoc. Is this normal behavior?

    Thanks

    Can we see one of the queries, please? Thanks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)