title: How divide the database up into into smaller databases
body: <p>I have a big SQL Server 2012 database.</p>
  
  <p>I want to split it into preferences and data.</p>
  
  <p>However I find that SQL Server does not seem to support the idea of dividing your data up into object oriented databases. It seems to rely on everything being in the same database.</p>
  
  <p>For example foreign keys are not supported in database. Also cross database joins are a real pain to do.</p>
  
  <p>How would someone typically go about doing this? Is it just a limitation of SQL Server that I should use the same DB for everything? </p>