Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Best way to select a large amount of data? RE: Best way to select a large amount of data?

  • August 21, 2010 at 8:54 am

    #1210027

    Stefan_G (8/20/2010)

    There will be blocking - another application will not be able to insert data into the table until the application has finished reading all the data.

    It depends. It depends on what the indexes are (especially the clustered index for inserts) and what the scope/range of data is being selected. Tables are not necessarily totally locked just because someone selects a large number of rows. 5M out of 120M is only a little over 4% of the table and can easily "survive" on page locks alone.

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