Features Available in SQL SERVER 2008

In this post we are going to see the New Features available in the SQL SERVER

•  New DataType [Date, time, FileStream] 

         DECLARE @date DATE

         DECLARE @time TIME

•       Compouned Operations [+=,-=,*=,/=]                

         DECLARE @i INT = 1

         SELECT @i+=2

         SELECT @i

•       Merge Statement  

MERGE INTO [targettable] AS t

USING [sourcetable] AS s

ON t.[column] = s.[column]

WHEN MATCHED THEN

-- statements

WHEN NOT MATCHED THEN

-- statements

•       Sparse Columns
•       Table value parameters
•       Integrated Full Text search
•       Intellisense
•       Transparent Data Encryption (Encrypt whole database explicitly)
•       Resource Governor
•       Policy Based Management
•       Linq