Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I agree....

Just to nit-pick: This will depend on the settings of ANSI_NULL_DEFAULT_OFF / ANSI_NULL_DEFAULT_ON for the session, or by the ANSI_NULL_DEFAULT database option. By default, these will be set such that...

Of course! That's obviously clear from the question😋

I would argue that in principle the explanation is correct. However, in the example given, this would result in zero rows, unless a very specific set of conditions are met....

Maybe it's a good idea to refrain from answering this until the correct answer has been reviewed...

It does, but there are two problems with that:

1. It's not among the given alternatives

...

Easy enough. But I would personally assign whoever created that table with DATETIME instead of DATE to toilet cleaing duty for a week...

Well, there's usually not much real body to New Year's resolutions...

Brilliant! So now those of us who answered master_files are flagged as giving a completely incorrect answer, rather than an equally correct alternate answer.

I concur.

Dearie me!

Reading the exact same doccumentation pointed out in the reference, I deduced that the result should be 'x' for the single char column, and 'xxxx' for the longer column,...

Yeah, I think I'll sit this one out for a bit...

Ooops!

This isn't the first time I've accidentally clicked on the "Featured Script" link instead of the "Question of the Day" link. And to add to my confusion, I misread  "Can...

You know, I kind of prefer the kinds of questions where there is a way to answer the question 😀

Well, this doesn't make sense. If 'radix' sort is named the fastest method for vectors of integers, and this is the method selected for those when 'auto' is specified, then...