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 user access mode in MSSQL Server?

MSSQL Server provides a feature to restrict your Database access for users. It can be performed...

Fix - Microsoft SQL Server, error: 10053 - An established connection was aborted by the software in your host machine

One of our Windows VPS customers received following error while connecting to MS SQL server....

Can I create unlimited MS SQL databases with unlimited database size?

Shared/Reseller Hosting: In Windows Shared/ Windows Reseller hosting you can create MS SQL...

How to install MS SQL Server 2016?

Microsoft® SQL Server® 2016 is the latest version of Microsoft's relational database management...

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

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