SQL Server 2008 VS SQL Server 2012
Difference between sql server 2008 and sql server 2012
S.No | SQL Server 2008 | SQL Server 2012 |
1. | PowerShell Supported | Enhanced PowerShell Supported |
2. | The SQL Server 2008 uses 27 bit bit precision for spatial calculations | The SQL Server 2012 uses 48 bit precision for spatial calculations |
3. | SQL Server 2008 is code named as Katmai. | SQL Server 2012 is code named as Denali |
4. | 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. |
5. | 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 |
6. | Exceptions handle using TRY….CATCH | Unique Exceptions handling with THROW |
7. | High Availability features as Log Shipping, Replication, Mirroring & Clustering | New Feature ALWAYS ON introduced with addition of 2008 features. |
8. | 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. |
9. | Could not supported for Windows Server Core Support. | Supported for Windows Server Core Support |
10. | 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. |
11. | 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. |
12. | 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. |
13. | EXECUTE with RECOMPLIE feature | Enhanced EXECUTE with many option like WITH RESULT SET |
14. | Maximum numbers of concurrent connections to SQL Server 2008 is 32767 | SQL server 2012 has unlimited concurrent connections. |
15. | TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008 | TRY_CONVERT() and FORMAT() functions are newly included in SQL Server 2012 |
16. | ORDER BY Clause does not have OFFSET / FETCH options for paging | ORDER BY Clause have OFFSET / FETCH options for paging |
18. | 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. |
19. | The Full Text Search in SQL Server 2008 does not allow us to search and index data stored in extended properties or metadata. | The Full Text Search in SQL Server 2012 has been enhanced by allowing us to search and index data stored in extended properties or metadata. Consider a PDF document that has “properties” filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it’s possible now. |
20. | Analysis Services in SQL Server does not have BI Semantic Model | Analysis Services will include a new BI Semantic Model (BISM). BISM is a(BISM) concept. 3-layer model that includes: Data Model, Business Logic and Data Access |
No comments: