Blog

Difference between SQL Server 2008 and SQL Server 2012

By Akash Garg Blogs | SQL Apr 08, 2013
In this blog differences between SQL Server 2008 and SQL Server 2012 are shown

Introduction

Many New Features have been provided with the New SQL Server 2012. In this Blog I had provided these features in the way of difference between the older and New version of SQl Server.

SQL Server 2012
  1.  Its Code Name is Denali.
  2. Its have unlimited concurrent connections.
  3. New Function Are available such as CONCAT(), FORMAT() and TRY_CONVERT().
  4. Data visualization is available by which we can take snapshot of data.
  5. It Use 48 bit precision for Spatial Calculation.
  6. In this Server, server down time is reduced by 50% , hence OS patching is not rebooting n times.
  7. This Server Have high availability and disaster recovery factor has been introduced which duplicates the data and rapidly recovers the loss.
  8. In SQL Server 2012, the performance is 10 times faster than the predecessor.
  9. Buffer rate is high in SQL Server 2012 because of data compression.
  10. Support for persistent computed columns and extra geographical approach is possible with spatial features in SQL Server 2012.

SQL Server 2008

  1. Its Code Name is Kilimanjaro.
  2. Its have limited concurrent connections which are 32767.
  3. There are No  New Function Are available such as CONCAT(), FORMAT() and TRY_CONVERT().
  4. There are No Data visualization  available by which we can take snapshot of data.
  5. It Use 27 bit precision for Spatial Calculation.
  6. In this Server, rebooting is requisite for OS patching , hence server down time is high.
  7. This Server  does not have this feature of availability groups, hence fast recovery is not possible.
  8. SQL Server 2008  is slow compared to SQL Server 2012.
  9. Buffer rate is less because there is no data redundancy in SQL Server 2008.
  10. Spatial features are not supported more in SQL Server 2008 R2. Instead a traditional way for geographical elements have been set in SQL Server 2008.
COMMENT USING