OK, I got it wrong, but I find this sentence slightly misleading:

"Even though you got it wrong, no points are deducted from your overall score"

While it is true that nothing...

This sure is the best way of doing it, but strictly speaking, if performance was my only concern, then using symmetric encryption in both cases would be the best choice,...

Steve,

You're right about being confused about the processor discussion...

The cores in hyperthreading processors might be viewed as separate processors that share the housing. But they share more than the casing:...

Is this an error in SQL Server or can it be used for something useful?

The funny thing is that in

select cast('This is a test' as varchar)

the varchar size defaults to 30, so in this case the full string is returned.

Could you please doa bitof proof reading before posting the QOD? ;+}

Humor?

Just to make the lesson a bit more useful you should add that you can use WITH VALUES or NOT NULL to get the new column populated with the default...

Does anybody know what these points can be used for?

That was a childish question!

This is not the correct answer. The explanation states that 'the relational operators UNION, INTERSECT, TIMES, and JOIN are commutative', so the answer ought to be 'a, c and d...

Due to an error in SQLServerCentral's code they're doing HTMLEncode on the link's HREF enclosed in quotes instead of doing HTMLEncode on the HREF and then enclose in quotes.

Regards

Mads Holm

Disabling a possible Instead of trigger OR executing a SET ROWCOUNT 100000 and rerunning the query could both be correct answers, but if the commands mentioned in the questions are run from...