Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Difference between SQL Server 2008 R2 and SQL Server 2012
08-29-2012, 07:53 PM
Post: #1
Difference between SQL Server 2008 R2 and SQL Server 2012
SQL Server 2008 R2 (SQL Server 10.5) :

1.SQL Server 2008 R2 is codenamed as Kilimanjaro
2.In SQL Server 2008 R2 , rebooting is requisite for OS patching , hence server down time is high
3.SQL Server 2008 R2 does not have this feature of availability groups, hence fast recovery is not possible.
4.SQL Server 2008 R2 is slow compared to SQL Server 2012.
5.However buffer rate is less because there is no data redundancy in SQL Server 2008 R2
6.Data visualization is not supported in SQL Server 2008 R2
7.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 R2.

SQL Server 2012 (SQL Server 11) :

1.SQL Server 2012 is codenamed as Denali
2.In SQL Server 2012, server down time is reduced by 50% , hence OS patching is not rebooting n times.
3.In SQL Server 2012, high availability and disaster recovery factor has been introduced which duplicates the data and rapidly recovers the loss.
4.In SQL Server 2012, the performance is 10 times faster than the predecessor.
5.Buffer rate is high in SQL Server 2012 because of data compression.
6.Data visualization tool is available in SQL Server 2012.This allows snapshots of data.
7.Support for persistent computed columns and extra geographical approach is possible with spatial features in SQL Server 2012.

Reference: http://onlydifferencefaqs.blogspot.in/20...08-r2.html

01-02-2013, 12:18 PM
Post: #2
RE: Difference between SQL Server 2008 R2 and SQL Server 2012

The below link will provide some new difference between sql server 2008 and 2012

Possibly Related Threads...
Thread: Author Replies Views: Last Post
  PIVOT table in sql server(Power of PIVOT) Lalithdotnetobject 0 3,582 12-20-2013 05:43 AM
Last Post: Lalithdotnetobject
  Common SQL Server Interview Questions and Answers magnum_2007 2 10,478 02-27-2013 10:47 AM
Last Post: Shafiur Rahman
  Differences between ISNULL and COALESCE Functions in SQL Server umarali1981 2 4,439 12-13-2012 01:01 PM
Last Post: umarali1981
  Difference between SQL Server 2008 and SQL Server 2012 umarali1981 0 4,599 08-18-2012 04:54 PM
Last Post: umarali1981
  MS SQL Server developer interview Question Shafiur Rahman 5 8,420 04-22-2012 06:04 AM
Last Post: jayanth2376

User(s) browsing this thread: 1 Guest(s)