chora (ch*****@hotmail.com) writes:
Hi, there is an existing application running on a SQL Server database.
Now I have to built a different app, which will have two common tables
with the existing database (Customers, sales)
Is there any benefit (performance mainly) creating the tables for the
new app in a new database? (On the same machine and the same instance)
There is too little information to say anything with certainty. If the
two apps not only share the table definitions, but also the data in
the table, putting everything in the same database.
As long as the applications are access their individual tables, there
is not much interferance between them. All I can think is that autogrow
caused by one app will affect the userss of the other app two, but
autogrows should not occur frequently.
Of course, in the common tables there may be blocking issues with
improper application design.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp