I would think the Grant's answer meant "Nope, it didn't". Much like if one were asked "Didn't you like that meal?" and the response was "Nope". Which would mean that...

Hi Steve,

Yes please keep the daily tips coming.

During my entire childhood my Mom would always have "cake and coffee" around 3pm every day. No kids, no husband, no housework, nothing...

The ORDER BY can only appear after the second query in an EXCEPT or INTERSECTION operator and only reference columns from the left (first) query.

This would work:

SELECT E.FIRSTNAME

FROM @EMPLOYEE E

EXCEPT

SELECT...

• This reply was modified 4 years, 1 month ago by  AZ Pete.

Hello Aveek,

Thanks for the excellent, detailed article. I wanted some clarification on the network set up. In the article you configured the instance to listen on network port TCP 1434....

Very helpful. Thanks Sue!

Hi Steve,

I live in Phoenix, AZ and have traveled to SQL Saturdays in:

Phoenix (of course 🙂 )

Las Vegas, NV

Silicon Valley (Mtn View), CA

I've also considered traveling to the SQL Saturdays...

Orlando - Thanks for the reply. There are no foreign keys pointing to this column, so nothing to drop & recreate and as a result no other columns need altering....

Thanks guys for your advice. The table is very large - about 250GB. I'd rather not have to make a duplicate of the data if I don't have to. Would...

Thanks folks for the replies. However, my question is *why* did SQL Server elect to use the unique index defined on the TransmissionId column versus using the Primary Key (defined...