I was assuming the "=" missing was a typo (which is so common here).

The answer is AES_128 | AES_192 | AES_256 ONLY for 2016. To use the Triple_Des you have to drop the compatibility level of the database below the 2016 (130) version....

The only way using alt alone works is with the mouse which you shouldn't be using with short cuts anyway. Defeats the whole purpose. alt+arrow moves objects in the code....

The answer is not correct. 9.0 is not 9.000000. The precision is different. 😀

I missed it for a different reason. I was guessing he intended sparse column so I knew it wouldn't compress but the statement isn't the cause of the error. The...

I checked the correct answer, was told it was the correct answer, but was told my answer was wrong. :/

Got told I was wrong again for the right answer. +1

I always look forward to being told I'm wrong for giving the correct answer. Someone fix this QotD please.

I took the error answer since it could have been either that one or '2' depending on which version of SQL server you are running on. When there are two...

Answer 4 is NOT as correct answer as that column doesn't exist. 🙂

Selected 5, told I was wrong. The correct answer is 4. Then told all results are returned.

QTF?

You didn't really say "named instance" in the question. You said "known as". Why would you place a named instance on a single instance server?

Steve,

The "correct answer" is incorrect depending upon how you define 'different'.

The 'correct answer' is incorrect depending upon how you define "different".

The 'correct answer' is incorrect depending upon how you define...