Home Forums SQL Server 2005 SQL Server Express Update statement times out on a small table RE: Update statement times out on a small table

  • December 26, 2014 at 11:40 am

    #1766504

    Each client computer updates its own row every second with the latest data.

    1. Can we see the UPDATE code, please?

    2. Are there any other indexes on the table?

    3. What are the types of values in Col1?

    4. Have you checked the SQL Server logs for deadlocks?

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