title: Cross database queries, joins advantages and disadvantages
body: <p>I am in a state of confusion that what are the advantages and disadvantages of using cross database queries within the same SQL Server instance?</p>
  
  <p>One thing I can think of is the performance issue (queries will be slow) if that the case what is the solution of this problem? </p>
  
  <p>Kindly highlight some advantages and disadvantages with solution so that I can work on the two database confidently .</p>
  
  <p>I have two databases db1 Companies/CRM and db2 Products/E-commerce</p>