Difference between SQL Server 10.5 and SQL Server 11.0
S.NoSQL Server 2008 R2SQL Server 2012
1 SQL Server 2008 R2 is codenamed as Kilimanjaro SQL Server 2012 is codenamed as Denali 2In SQL Server 2008 R2 , rebooting is requisite for OS patching , hence server down time is highIn SQL Server 2012, server down time is reduced by 50% , hence OS patching is not rebooting n times. 3SQL Server 2008 R2 does not have this feature of availability groups, hence fast recovery is not possible.In SQL Server 2012, high availability and disaster recovery factor has been introduced which duplicates the data and rapidly recovers the loss. 4SQL Server 2008 R2 is slow compared to SQL Server 2012.In SQL Server 2012, the performance is 10 times faster than the predecessor. 5However buffer rate is less because there is no data redundancy in SQL Server 2008 R2Buffer rate is high in SQL Server 2012 because of data compression. 6Data visualization is not supported in SQL Server 2008 R2Data visualization tool is available in SQL Server 2012.This allows snapshots of data. 7Spatial features are not supported more in SQL Server 2008 R2. Instead a traditional way for geographical elements have been set in SQL Server 2008 R2.Support for persistent computed columns and extra geographical approach is possible with spatial features in SQL Server 2012.