• I'd keep staging in a separate database, because that gives you the flexibility to set whatever recovery model, backup schedule, log truncation, and other database options are optimal for staging without interfering with the normal operation of the production data warehouse. Having staging and DW in the same database, I believe you would find yourself having to make too many compromises and trade offs.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho