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) );Included columns and filter conditions are not supported with inline indexes.
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.