Good: Correct answers: 95% (70)

I never saw a qotd with 100% of correct answers.

By the way:

I often use NULLIF when 3rd party application use MAGIC VALUES instead of NULL.

e.g. 1799-12-31 stands for NULL DATETIME.

Here's a generic example to get an actual...

BIG ERROR: I answered thinking at the first 3 columns, so that Y would return without...

Is FAT32 still alive?

FAT32 is deprecated because of...

Great question.

Hugo, you are the number ONE!

Thanks.

😀

Good question!

Koen Verbeeck (4/17/2012)

---

They will all be...

I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.

Nakul Vachhrajani (4/15/2012)

---

The way I interpreted the question was:

1. Database is in full-recovery mode

2. User foresees bulk-operations (i.e. to be performed sometime in the future)

3. User therefore changes the database...

I do not like this kind of EXTREMELY easy questions.

😀

Another tricky and bad worded question.

In the earlier versions of any DBMS, the foreign key was implemented thru triggers.

So the answer should be "YES, implemented by trigger."

Or change the question:...

Good question!

Thanks.

😛

I tried on my production server:

I got interesting results

ordering by [Total IO] instead of [Average IO].

Thanks!

cengland0 (3/30/2012)

---

This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. ...

New features are welcome!

But, I get it wrong!

😛