Nice question. What is most interesting to me is why 23% (as of now) got it wrong.

I can see thinking that

select dateadd( ss, -1, datediff(yy, 0, @ThisDate) + 1 )

is...

Thanks for the question. Interesting stuff, even if it will be 2020 before I get to use 2014 in a production environment.

I note that under "Index Count" it says:

Do not...

Thanks for posting this Paul. It has motivated me to revise my backup/restore plans. I now restore the production backup to my test DB immediately after backup, and use CHECKSUM...

Thanks to Thava for the question. It usually makes a good question to point out those areas in SQL Server where the actual behavior doesn't match the expected behavior.

(Edited to...

Good question. I confess that I saw Central Management Server, and dismissed it as a dummy name for the servers related to SQL Server CENTRAL. Sigh.

At least I learned something....

Wasn't really sure when I clicked 'submit'. I would have thought that KEYSET was a TYPE of cursor, and not the operator that generated the cursor.

For example (stolen from a...

Nice question and good feature. Makes rolling calcs easier.

Easy question, which I got wrong, as I seem to have missed the word "cannot" (in bold font) and the number "2". I prompted selected the three that CAN and...

What kind of compression ratio have you obtained?

It's still...

Since

Abs((@start + (@commonDiff * (@counter -1))) -

Round((@start + (@commonDiff * (@counter -1))), 1, 1)) * Power(10, 1) = 5

would never evaluate to true, the rest was easy enough...

How about an ANSI compliant DBMS that runs on an operating system that doesn't drive you crazy that sells for less than $2000? 😉

Thanks for the question. I like the suggestion in the reference to run CMS on a development box. Another reference I found explicitly suggested using a developer version to save...

Yes! Had a heck of a time figuring it out, UNTIL I realized it must be something...

When I first saw the question (without seeing possible answers), I thought this was about the source of the term "Hekaton". (Megaton, Gigaton, ... Hekaton???) Glad it was easier than...