The motivation for this question is with regard to staging tables. Should staging tables be in a separate database for performance reasons? Or can you place staging tables and your destination tables all in one database (using "staging" as schema) without any performance impact on reads of your final tables?
My hunch is I don't think it matters where the staging tables are located, if they are on the same server, but I have nothing to back that up. If there is a performance hit, why?