USE tempdb
GO

IF OBJECT_ID('tempdb.dbo.Covered') IS NOT NULL DROP TABLE Covered
IF OBJECT_ID('tempdb.dbo.Included') IS NOT NULL DROP TABLE Included
SET NOCOUNT ON;
CREATE TABLE Covered
(
	 RowID	INT IDENTITY(1,1)
	,Col1	INT NOT NULL
	,Col2	INT NOT NULL
)

CREATE TABLE Included
(
	 RowID	INT IDENTITY(1,1)
	,Col1	INT NOT NULL
	,Col2	INT NOT NULL
)
GO

INSERT INTO Covered
SELECT TOP 100000 
		 ABS(CHECKSUM(NEWID()) % 100)
		,ABS(CHECKSUM(NEWID()) % 10000)
FROM sys.syscolumns T1, sys.syscolumns T2, sys.syscolumns T3
GO 10

INSERT INTO Included
SELECT TOP 100000
		 ABS(CHECKSUM(NEWID()) % 100)
		,ABS(CHECKSUM(NEWID()) % 10000)
FROM sys.syscolumns T1, sys.syscolumns T2, sys.syscolumns T3
GO 10


CREATE INDEX c_Covered	ON Covered (RowID)
CREATE INDEX c_Included	ON Included (RowID)

CREATE INDEX nc_Covered		ON Covered (Col1, Col2)
CREATE INDEX nc_Included	ON Included (Col1) INCLUDE (Col2)

SELECT COUNT(*)
FROM Covered
WHERE Col1 > 60 
AND Col2 > 9998

SELECT COUNT(*)
FROM Included
WHERE Col1 > 60 
AND Col2 > 9998

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass