Home Forums Article Discussions Article Discussions by Author Discuss content posted by ~~Hari.Bagra Get Record Count for each table in a database. RE: Get Record Count for each table in a database.

  • August 10, 2008 at 9:37 am

    #855759

    toniupstny (8/10/2008)

    An alternative without cursor is:

    sp_msforeachtable 'select ''?'', count(*) Rows from ?'

    Toni

    Ummm.... not quite correct, Toni. If you go and look at the code for sp_MSForEachTable, you'll find a monster cursor that is typically slower than any cursor you would ever intentionally build because it was written to handle just about any size code. The cursor that Hari wrote will likely run much faster than using sp_MSForEachTable.

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