I just have little knowledge on SQLServer administration.
The scenario is :
We plan to install SQLServer Enterprise 2005 in Windows Server . and on the same server , we will create 7 database which will basically running different business for different application users. In most of cases , the use of database is separated , but for some management report purpose , We need to generate some very high level reports which could join table from serveral databases .
My worry is :
1. When we create serveral database in the same server , are they sharing the same sqlserver instance ? On the other words , the Database in SQLServer behaviour very different from oracle database from the instance memory management point of view?
2. When we write sql which join tables from several database , The book told me I have to create serverlink , Is there any other shortcut ?
3. Since there are some global master tables which could be shared by all databases , If we create those business master tables in each database , it seems a kind of waste of space . So is it possible to create business master tables in a kind of 'common place' and later it could be shared by all the other databases?
4. Finally , the last question is where is the 'best sqlserver forum? ' So that I could learn something specific