That is going to be determined by SQL Server based on the query.  If SQL Server determines that Key lookup is faster to satisfy the query than a clustered index...

I see no rhyme or reason to how you are putting together your start and end dates based on the dates posted.  Care to explain this a little better?

Actually, it is sargable.  One of the quirks of the date/time...

Or:

SELECT [mycrap]
FROM [mytable]
WHERE
    CAST([mydate] AS DATE) = DATEADD(DAY,-7,CAST(GETDATE() AS DATE))


I just see too many job posting that state upfront, no telecommute available.

I like the company where I work, just a 10 minute commute at this time.  Even...

I do have to agree with Jeff.  But I will also say there is nothing like getting feedback on things you are finding as you may find yourself dealing more...