• Mark Eckeard (9/16/2012)


    All,

    ** I think this is the appropriate forum but please let me know if not and I'll move it **

    My company is beginning to discuss setting up a data warehouse so we can do reporting from our numerous sources. Since I'd like to get a head start, I figured I'd ask if anyone had a good book or resource for this.

    We'll be using SQL 2k8 R2 pulling data from the production databases to the BI/DW/whatever-its-called server where the reports will run.

    Thanks,

    Mark

    Depending on the condition of the database, you might not need to go through the rigors of setting up a a data warehouse. Just write some good reporting code.

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