Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. We don't offer MSSQL Server 2008 anymore.
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
|