Comparison of MS SQL Server 2008 V/s. MS SQL Server 2012

Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012.

MS SQL Server 2008 MS SQL Server 2012
  • MS SQL Server 2008 supports 32767 concurrent connections
  • MS SQL server 2012 has unlimited concurrent connections.
  • The SQL Server 2008 uses 27 bit precision for spatial
  • The MS SQL Server 2012 uses 48 bit precision for spatial
  • PARSE , TRY_CONVERT, TRY_PARSE functions are NOT available in MS SQL Server 2008
  • MS SQL Server 2012 provides new conversion functions such as PARSE , TRY_CONVERT, TRY_PARSE
  • String functions CONCATE and FORMAT are NOT available
  • CONCATE and FORMAT string functions are available.
  • MS SQL Server 2008 can support 1000 partitions
  • MS SQL Server 2012 can support 15,000 partitions
  • Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions are NOT available in MS SQL Server 2008
  • Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions are introduced to perform operations on Packages
  • ORDER by Clause does NOT have OFFSET / FETCH
  • ORDER by Clause provides OFFSET / FETCH options



  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to change Database Collation in MsSQL Server?

Collation is a configuration level setting in the MSSQL. It directs how the character data will...

Microsoft SQL Server 2014 Recommendation

The SQL Server 2014 Express is yet another feature-rich data management system from Microsoft....

How to take MSSQL database offline or bring it online?

Sometimes, you come across to a situations when you are required to physically move the database...

How do I connect to MSSQL Server 2008 from SQL Server Management Studio?

This article will guide you on how to connect to MS SQL Server 2008 from SQL Server Management...

Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....