Differences between SQL Server 2008/R2 and 2012
Sr. No. | Sql server 2008 R2 | Sql server 2012 |
1 | Exceptions handle using TRY….CATCH | Unique Exceptions handling with THROW |
2 | High Availability features as Log Shipping, Replication, Mirroring & Clustering | New Feature ALWAYS ON introduced with addition of 2008 features. |
3 | Web Development and Business Intelligence Enhanced with business intelligence features. Excel PowerPivot by adding more drill and KPI through. | In Addition with SQL server 2008, Web Development and Business Intelligence Enhanced with business intelligence features and Excel PowerPivot by adding more drill and KPI’s. |
4 | Could not supported for Windows Server Core Support. | Supported for Windows Server Core Support |
5 | Columnstore Indexes not supported. | 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. |
6 | PowerShell Supported | Enhanced PowerShell Supported |
7 | Distributed replay features not available. | Distributed replay allows you to capture a workload on a production server, and replay it on another machine. This way changes in underlying schemas, support packs, or hardware changes can be tested under production conditions. |
8 | 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. |
9 | EXECUTE … with RECOMPLIE feature | Enhanced EXECUTE with many option like WITH RESULT SET…. |
10 | Maximum numbers of concurrent connections to SQL Server 2008 is 32767 | SQL server 2012 has unlimited concurrent connections. |
11 | The SQL Server 2008 uses 27 bit bit precision for spatial calculations. | The SQL Server 2012 uses 48 bit precision for spatial calculations |
12 | TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008 | TRY_CONVERT() and FORMAT() functions are newly included in SQL Server 2012 |
13 | ORDER BY Clause does not have OFFSET / FETCH options for paging | ORDER BY Clause have OFFSET / FETCH options for paging |
14 | SQL Server 2008 is code named as Katmai. | SQL Server 2012 is code named as Denali |
15 | In SQL Server 2008, audit is an Enterprise-only feature. Only available in Enterprise, Evaluation, and Developer Edition. | In SQL Server 2012,support for server auditing is expanded to include all editions of SQL Server. |
16 | Sequence is not available in SQL Server 2008 | Sequence is included in SQL Server 2012.Sequence is a user defined object that generates a sequence of a number |
Great article,Thank you for sharing this awesome Post.
ReplyDeleteKeep updating....
Microsoft BI Training Online
Thank you for your valuable feedback
Delete