SQL Server 2014 T-SQL Enhancements

Inline index creation

Both clustered and nonclustered indexes can be created inline

create table client
 (first_name varchar(20) index cli_name,
  last_name varchar(40) index  cli_fullname nonclustered (last_name,first_name)
  );

SELECT INTO is now done in parallel

As per italian premier center for sql server

Database compatability level must be 110 or higher

First we add 2 tables to our database djw1

Then we execute the query with the actual query plan displayed

Properties on the select into operator show the degree of parallelism on the quad core VM.

Finally there are the Hekaton extensions