Home Forums SQL Server 2005 SQL Server 2005 General Discussion optimize queries RE: optimize queries

  • October 20, 2009 at 5:37 pm

    #1068609

    You shouldn't have to partition anything for a 7k row table because it won't help when returning all rows and columns.

    Something is dreadfully wrong if it takes that long to return just 7k rows... please post the CREATE TABLE statement and also tell us how far away you are from the actual server.

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