The below are the differences between SQL Server 2008 R2 and SQL Server 2012.
1.Code name for SQL 08 R2 is Kilimanjaro where as code name for SQL 2012 is Denali .
2.In 2008 R2 exceptions can be handled using TRY….CATCH where as in SQL 2012
exceptions can be handled with THROW too .
3.In 2008 R2 high availability features such as Log Shipping, Replication, Mirroring , Clustering
are available where as in 2012 new feature ALWAYS ON is introduced with addition of 2008 features.
4.In 2008 R2 there are no Columnstore Indexes where as in 2012 new Columnstore Indexes feature that is completely unique to SQL Server. They are special type of read-only index designed to be use with Data Warehouse queries. Basically, data is grouped and stored in a flat, compressed column index, greatly reducing I/O and memory utilization on large queries.
5.In 2008 R2 maximum numbers of concurrent connections are 32767 where as in 2012 unlimited
concurrent connections.
6.TRY_CONVERT() and FORMAT() functions are newly included in SQL Server 2012 only .
7.ORDER BY Clause have OFFSET / FETCH options for paging in SQL Server 2012 only .
8.In 2012 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.
9.In 2008 Data visualization is not supported in SQL Server 2008 R2 where as in 2012
Data visualization tool is available in SQL Server 2012.This allows snapshots of data.
10.In 2008 R2 query page splitting is not available where as in SQL 2012 query page splitting is implemented.
11.In 2008 R2 maximum partition support is 1000 where as in SQL 2012 maximum partition support is increase from 1000 to 15000.
12. BI Semantic model (BISM ) is introduced for Analysis series in SQL 2012 with 3 layers that are Data Model , Business Logic and Data Access .
13. CONCATE and FORMAT functions are introduced in SQL 2012 .
14. Buffer rate is high in 2012 because of data compression .
1.Code name for SQL 08 R2 is Kilimanjaro where as code name for SQL 2012 is Denali .
2.In 2008 R2 exceptions can be handled using TRY….CATCH where as in SQL 2012
exceptions can be handled with THROW too .
3.In 2008 R2 high availability features such as Log Shipping, Replication, Mirroring , Clustering
are available where as in 2012 new feature ALWAYS ON is introduced with addition of 2008 features.
4.In 2008 R2 there are no Columnstore Indexes where as in 2012 new Columnstore Indexes feature that is completely unique to SQL Server. They are special type of read-only index designed to be use with Data Warehouse queries. Basically, data is grouped and stored in a flat, compressed column index, greatly reducing I/O and memory utilization on large queries.
5.In 2008 R2 maximum numbers of concurrent connections are 32767 where as in 2012 unlimited
concurrent connections.
6.TRY_CONVERT() and FORMAT() functions are newly included in SQL Server 2012 only .
7.ORDER BY Clause have OFFSET / FETCH options for paging in SQL Server 2012 only .
8.In 2012 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.
9.In 2008 Data visualization is not supported in SQL Server 2008 R2 where as in 2012
Data visualization tool is available in SQL Server 2012.This allows snapshots of data.
10.In 2008 R2 query page splitting is not available where as in SQL 2012 query page splitting is implemented.
11.In 2008 R2 maximum partition support is 1000 where as in SQL 2012 maximum partition support is increase from 1000 to 15000.
12. BI Semantic model (BISM ) is introduced for Analysis series in SQL 2012 with 3 layers that are Data Model , Business Logic and Data Access .
13. CONCATE and FORMAT functions are introduced in SQL 2012 .
14. Buffer rate is high in 2012 because of data compression .
No comments:
Post a Comment