SQL Server Denali CTP3 - What's New?

You may already downloaded SQL Server Denali CTP1 and hope you practiced all the new features of CTP1. You can also read the new features of CTP1. I have downloaded SQL Server 2011 CTP3 and get started to review new features arrived with it. After completion of CTP1 review, you can download CTP3 here, You can choose 32 or 64 bit version.

Let us look at some of the new features provided by this latest CTP. So have a look, Some of the new features are listed below from which I have taken as a reference.

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)
11.Support online index rebuild with varchar(max), nvarchar(max), and varbinary(max) columns.

I have posted some links below which I have learned with examples,
1.IIF - Returns one of two objects, depending on the evaluation of an expression
2.EOMONTH - Returns End Date of Month
3.New analytical functions, First_Value & Last_Value
4.CONCAT - Used to concatenate two or more strings
5. COLUMNSTORE Index
6. PERCENT_RANK() and CUME_DIST()
7. FORMAT - Returns formatted value from specified format of DATETIME
8. TIMEFROMPARTS
9. DATEFROMPARTS
10. PERCENTILE_CONT() and PERCENTILE_DISC()
11. sys.dm_server_services
12. LEAD() and LAG()
13. Partition support increased
14. Supports Rebuild online index with varchar(max),nvarchar(max) and varbinary(max) columns  
15. TRY_CONVERT
16. PARSE ()
17. TRY_PARSE()
18. FORCESEEK and FORCESCAN

You can learn all justlearned which i have submitted. I have also not completed practical and practice of all the listed features, but i will review all the new features as soon as possible and will post in future. Please comment when you found new.