Hugo Kornelis (3/11/2013)

---

Dave62 (3/11/2013)

---

I'm thinking about including a question like this in an interviewing process.

I don't agree. I happened to know this one because I was already using SQL Server at the end of the previous century (wow, putting it like that really makes me feel old!) But how many people who started using SQL Server more recently would know this? I would be perfectly fine with employees who frankly admit that they'd have to look up (or experiment) to predict what SQL does with a two-digit year. And if I found someone who did know this, I'd still want to know if (s)he has been keeping up to date, or is still on knowledge of SQL 7.0 and SQL 2000 only.

QotD's like this may be a great resource for putting together a quick and effective screening process! 😉

Some QotD's could be used in an interview, but the large majority are more trivia-type questions and less about knowledge required for real-world SQL Server jobs.