I have a query that uses tables from two different databases in the same server. Is there any serious performance overhead or degradation with this setup? Would the query run significantly faster if all the tables were placed in only one database?
Your helpful insights would be greatly appreciated. Thanks in advance!