SQL Server 2008 - How fast are table joins across databases (same server) vs. tables in the same database?

Question

We're customizing a CMS that has a few hundred tables in it. We are considering moving our custom tables to a separate database on the same server.

Should we expect much of a slow down in SQL Server? There will be many multi-join stored procedures joining data across the CMS database and our custom database.

Answer 1

should not make an impact......however you can also use a schema instead and place all your tables under that schema in the same database. This way all your stuff will be logically grouped together