I'm running a variety of SQL Servers from 2005 to 2012 across several machines. I have many of these databases running in SQL Server 2000 compatibility mode.
Will using an older compatibility in a newer version of SQL Server cause any performance issues?
What is the different between these databases, other than older versions of SQL Server being able to access them?