Anyone remember what last Version of Visio that supported reverse engineering of databases?

Is there a tool like SSMS that can be run on a Mac or Linux laptop?

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...