Register now or log in to join your professional community.
There is money put I've seen the most value New Analytic Functions like FIRST_VALUE LAST_VALUE
add ORDER BY in the OVER for aggregate functios Like SUM AVG
CONCATE,FORMAT and PARSE where added in sqlserver2012 which were not present in sqlserver2008.
1)Sequence is not avaiable in SQL server2008.Sequence is included in SQL Server2012.
Sequence is a user defined object that generates sequence of the number.
2)The maximum number of concurrent connections to SQL Server2008 is32767.
SQL Server2012 has unlimited number of concurrent connections.
3)SQL Server2008 uses27bit precision for calculations.
Sql server2012 uses48 bit precision for calculations.
4)TRY_CONVERT() and FORMAT() functions are included in SQL server2012
But not available in SQL server2008.
In Addition with SQL server2008, Web Development and Business Intelligence Enhanced with business intelligence features and Excel PowerPivot by adding more drill and KPI’s.
