title: SQL Server Compatibility level implications
body: <p>A quick information question :</p>
  
  <p>On my SQL Server 2008, I have databases migrated from SQL Server 2005 and the Compatibility level of the databases on SQL Server 2008 are set to <code>90</code> (SQL Server 2005).</p>
  
  <p>What exactly are the implications of that?</p>
  
  <p>It means that the migrated stored procedures, triggers and functions will work well on SQL Server 2008, but are there any disadvantages? </p>
  
  <p>What could be the reason to set the compatibility level to <code>100</code> (SQL Server 2008) ?</p>
  
  <p>Performance? Extra features?</p>
  
  <p>Thanx</p>