Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich Loading a 24x7 Data Warehouse RE: Loading a 24x7 Data Warehouse

  • March 10, 2008 at 5:53 am

    #787292

    Leo Peysakhovich (3/9/2008)

    noeld (3/19/2007)

    A 10GB data warehouse is small enough to follow the proposed procedure.

    When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different ball game.

    Cheers,

    When you have 500G you strategy has to be changed. You may check if schema level can be replaced or another set of objects, or some other solutions. It is not as scary as people thinking. We have 80-100G statistical databases but the strategy is different.

    So, what strategy do you use?

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