Top 10 New Features of SQL Server 2012.

SQL Server 2012 Code name Denali arrived with New Features:
Some of new features are listed below:


1. New Built-in functions(t-sql):


-PARSE 
-TRY_CONVERT 
-TRY_PARSE 
-DATEFROMPARTS 
-DATETIME2FROMPARTS 
-DATETIMEFROMPARTS 
-DATETIMEOFFSETFROMPARTS 
-EOMONTH 
-SMALLDATETIMEFROMPARTS 
-TIMEFROMPARTS 
-CHOOSE (Transact-SQL)
-IIF (Transact-SQL)
-CONCAT (Transact-SQL)
-FORMAT (Transact-SQL)


2. Analytical Functions(t-sql):


-CUME_DIST 
-LAST_VALUE 
-PERCENTILE_DISC 
-FIRST_VALUE 
-LEAD 
-PERCENT_RANK 
-LAG 
-PERCENTILE_CONT 


3. SQL Server Express LocalDB


4. New Query Optimizer hints:
-ForceScan
-ForceSeek(Enhanced)


5. Extended OVer clause Enhancements:


6. Xevent Enhancements:


7. Database Tuning Advisor(DTA) Enhancements:


8. New Dynamic Management Views(DMVs) and function:


9. Partition Support Increased:


10.Columnstore Indexes(Data Warehouse query):


I will explain all new functions in my future posts.


Check out this link for more details SQL Server CTP3 2012