>DO you think store all tables in ONE database is better i\or seperate them into more?

You'll need to describe your application and where/how it will be run in more detail before you'll get a good answer.

I will say, however, that some people have a separate DBC just for views and each user has a copy of this DBC locally. It reduces contention issues when views are opened.