SQL Server 2014?????????????????

???????????? ???????[ 2015/7/1 16:37:55 ] ?????????????

??????Paul White???????????????SQL Server 2014????????????Table Variables????????????????????Non-Unique Clustered Indexes?????????????Non-Clustered Indexes????????????????????????????????????￡?????????????????????????????????????????????????excessive recompilations?????????????????????????????????????????????????????????????????TempDb?????????
?????????????????????????????洴??????????????????????????????????????SQL Server 2014 CTP1???????????????????????????????????????????????????м??????
1 DECLARE @tempTable TABLE
2 (
3    ID INT IDENTITY(1?? 1) PRIMARY KEY??
4    FirstName CHAR(100) INDEX idx_FirstName??
5    LastName CHAR(100)
6 )
7
8 INSERT INTO @TempTable (FirstName?? LastName)
9 SELECT TOP 100000 name?? name FROM master.dbo.syscolumns
10
11 SELECT FirstName FROM @TempTable
12 WHERE FirstName = 'cid'
13 GO

??????????????SELECT??????м????SQL Server??????????????????????Non-Clustered Index Seek operator???????????????????????????????????????????????????????????????????????????????????????????????????easy syntax???????????????????????壺
????1 CREATE TABLE foo
????2 (
????3     Col1 INT PRIMARY KEY CLUSTERED??
????4     Col2 INT INDEX idx_Col2??
????5     Col3 INT INDEX idx_Col3
????6 )
????7 GO
?????????SQL Server 2008R2?????????′???