>>Hi,
>>DO you think store all tables in ONE database is better i\or seperate them into more?
>>
>>Thank you
>
>We store static tables into separate database rather than putting them together into the same database that holds transaction tables. Another database holds local and remote views. In my opinion this approach is more organized than putting them into single database.
I suppose you would also keep your data-warehouse in a separate database, right? (I understand a data-warehouse as a special version of the database, optimized for reporting / analysis purposes, but not updated immediately, every time you make changes.)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)