Maybe I'm just being dense here but I got the question wrong and then started reading through the comments. I did some testing where I issued the query, issued the...

Doing the math based a world population of 7,700,000,000 people

• An estimated infection rate of ~40 -- ~70% infection rate [3,080,000,000 {3.080 Billion} to 5,390,000,000 {5.39 Billion} people infected
• An ...

I'm of the same mindset ( and apparently the same age demographic 🙂 ) as that is what I distinctly remember this standing for so hence, I got this one...

I also got this wrong this morning as I know that Checksum has been around for quite a few versions. I even went back and verified this on several of...

Count me in on the 100% wrong answers as well. I could have sworn dput parsed the input object and returned it to client. Oh well... It will be interesting...

Just to be clear, in my previous reply, the view definition in syscomments can be de-obfuscated in SQL Server 2000 for those of us who are still having to maintain...

Nice question and the answer was quite obvious. It should be pointed out though that just because you create a view WITH ENCRYPTION, it is still possible for users with...

Nice straightforward question this morning with no ambiguity in the possible answers.

Thanks Steve.

One has to wonder at what point will Microsoft add configuration switches (defaulted to force developers to use correct variable declarations) that would allow you to either work with backwards...

Yep, that makes sense.

Thanks

I got this one wrong but only after I tried using the script below on my SQL Server 2008 R2 environment.

Could someone explain why the script below allows me...

Whoo.Hooo..

2nd comment on this QOTD. Haven't been able to do that in quite a while. Thanks for the good question. I got it right as I just recently had to...

You're delete statement in your trigger is incorrect. You are attempting to delete the entire table without a where clause which is not what I think you want to do....

If you're a script / text based kind of person who doesn't like using the mouse (drag and drop) you can generate the script using the following.

Note: Zip file includes...