Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Query was executing fine and suddenly started taking time RE: Query was executing fine and suddenly started taking time

  • January 11, 2014 at 7:07 am

    #1679367

    Shadab Shah (1/10/2014)

    Just thought of giving a Update.

    The query is running with in the stipulated time.

    Nothing has changed over a period of time no server settings have changed not even query :doze:

    Has anybody faced this Issue. This is really puzzlling . What could be the root cause

    I have, indeed, run into such a thing. When it occurs, it's normally either due to a conflict with other things OR it's because the UPDATE is (what I call) an "illegal update". There is a particular form of the UPDATE statement that usually works but, in fact, is not mentioned anywhere in Books Online (which is why I call it "illegal").

    Please post the UPDATE statement that you were having troubles with so we can have a look.

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