Difference Between SQL Server 2008 and SQL Server 2012

Difference between Sql server 2008 and Sql server 2012 is a very common interview question and some times its the first question in interviews. So I collected some common difference below

Sno. SQL Server 2008 SQL Server 2012
1 Code name is Katmai Code name is Denali
2 Audit Feature is available only in Enterprise Edition.  Auditing feature is available in all editions of SQL Server.
3 Only 4 major High Availability features  Log Shipping, Replication, Mirroring & Clustering ALWAYS ON introduced as High availability feature with addition of 2008 features.
4 Failover was only possible for instance Failover of Database is also possible
5 Nothing called as ColumnStore Indexes Read only ColumnStore Indexes were introduced
6 No cointained database We have a new feature called Contained Databases
7 The BCP not support –K Option. The BCP Utility and SQLCMD Utility utilities enhanced with -K option, which allows to specify read-only access to a secondary replica in an AlwaysOn availability group.
8 PowerShell Supported Enhanced PowerShell Supported
9 The Full Text Search does not allow us to search and index data stored in extended properties or metadata. The Full Text Search is enhanced to search and index data stored in extended properties or metadata. 
10 ORDER BY Clause now have OFFSET / FETCH options to use paging to show required rows per page in applications and allow the user to scroll through each page of results rather than download the entire set ORDER BY Clause does not have OFFSET / FETCH options 
11 EXECUTE with RECOMPLIE feature Enhanced EXECUTE with many option like WITH RESULT SET….
12 This uses 27 bit bit precision for spatial calculations. This uses 48 bit precision for spatial calculations
13 Maximum numbers of concurrent connections  is 32767 Unlimited concurrent connections.
14 TRY_CONVERT() and FORMAT() functions are not available  TRY_CONVERT() and FORMAT() functions were newly introduded
15 Sequence is not available Sequence a user defined object that generates a sequence of a number is newly introduced
16 Analysis Services in does not have BI Semantic Model Analysis Services will include a new BI Semantic Model . It is a  concept. 3-layer model includes Data Model, Business Logic and Data Access
17 PowerView not available in BI features PowerView is a fairly powerful self-service BI toolkit that allows users to create mash ups of BI reports from all over the Enterprise.
18 sys.dm_exec_query_stats  sys.dm_exec_query_stats  added four columns to help troubleshoot long running queries. You can use the total_rows, min_rows, max_rows and last_rows aggregate row count columns to separate queries that are returning a large number of rows from problematic queries that may be missing an index or have a bad query plan.


No comments:
Write comments

Please do not enter spam links

Meet US


More Services