Thank you so much for the explanation!

DDL w/ index

USE [MaxF]

GO

/****** Object: Table [dbo].[Visits] Script Date: 02/22/2013 17:25:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Visits](

[id] [bigint] NOT NULL,

[Date] [smalldatetime] NULL,

[SiID] [int]...

Recap:

Query 1 has in the WHERE clause: "QueryID=@QID". As we can see from the statistics Query 1 does a ton more logical reads for the subqueries contain in the full...

Jeff, you are right. The second should take longer, but actually the 1st query takes MUCH longer in this case. I just don't understand why in this case.

Here are...