Home Forums SQL Server 2014 Development - SQL Server 2014 Query performance RE: Query performance

  • December 1, 2013 at 5:17 pm

    #1669966

    I would first ask the Developers how they knew they rolled everything back and how they knew they didn't drop something that they didn't add.

    The other thing might be that things are "stuck". In other words, maybe you need to do a DBCC FREEPROCCACHE followed by a DBCC DROPCLEANBUFFERS to get all of the stored procedures to recompile. Bear in mind that that act alone will make things run slowly at first because all of the data and procs that are normally cached will need to recache.

    --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)