A very valid question I thought, but one that's more about NOLOCK than EXCEPT, and the explanation should have included the comments later added.

What's "crazy" isn't the final sign. It's that SQL doesn't recognize unary minus. In math, and in every ordinary programming language I've ever encountered, unary operators have higher precedence...

I don't really understand the explanation. In what was is anything "crazy" about the handling of negatives? Whatever the precedence you end up dividing a negative by a negative, which...

Not to nit-pick, but the option is actually called ANSI_NULL_DFLT_OFF, so technically, all the answers are incorrect.

However, the database option is called ANSI_NULL_DEFAULT, which can be set to OFF...

However, if it were a varchar, why would you be converting it to a varchar..? Style codes only affected when convert to or from a varchar from another data type....

The answer depends on the data type of dbo.SalesHeader.OrderDate. If it's a datetime or similar then the answer is 6 as given. But if it's a varchar column then the...

None of the answers is correct. You can index a computed column based on a float as long as it is persisted.

Ignoring the fact that the dates are a week apart 😉

I did a search before replying and that told me that Colorado is also on daylight savings time in May,...

Guessed right but for the wrong reason.
Must admit, I don't quite see the point in teaching us about a feature that most of us have probably never heard of...

it also makes no attempt to validate the string you pass in, so
SELECT PARSENAME('x.y.z', 3)
will always return 'x'
ie it's a simple string-parsing method.

Surely...

also not so easy for anyone who answers based on the actual question 😉

Personally I would cast everything in sight to a decimal - implicit conversions are a complete pain, explicit casting will guarantee the correct result.

I don't think that's the right answer. It always returns nvarchar - but if the input is invalid then the nvarchar value is NULL
If you run 
select...