Home Forums SQL Server 7,2000 Performance Tuning OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server. RE: OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server.

  • January 30, 2009 at 5:53 pm

    #935919

    If someone or something has the file open when your code runs, it will give such an error message. Bouncing the server seems to clear it because the file is on the server and bouncing it forces a disconnect.

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