• Yogi Berra had a saying... "When you come to a fork in the road, take it!" In other words, given a choice, take all choices.

    A partitioned table would work very nicely here. It combines the benefits of have individual tables for each "customer" along with the benefits of have one huge table for all customers. It makes future archival processes simple, it makes adding new "customers" simple, it makes table maintenance simple, and it makes index maintenance both simple, relatively unobtrusive, and fast.

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