Home Forums Microsoft Access Microsoft Access Slow performance after Migration from Access to SQL back-end RE: Slow performance after Migration from Access to SQL back-end

  • June 26, 2011 at 4:40 pm

    #1344262

    If you do add a column to a table, make sure you rebuild at least the clustered index.

    As a side bar, you might want to avoid using ORDER BY X where X is an integer. First, it's considered to be a bad practice by lot's of folks for more than one reason and, second, it's been deprecated. 😉

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