Non-Clustered Indexes on Table Variables in SQL Server 2014

Earlier today I have seen a Tweet from Paul White, where he tweeted that SQL Server 2014 supports Non-Unique Clustered and Non-Clustered Indexes for Table Variables in SQL Server 2014. So I had to start up my virtual machine and try it out, because this would be a awesome new feature. Table Variables are great, …

Non-Clustered Indexes on Table Variables in SQL Server 2014 + read more