paul.knibbs (8/3/2012)

---

All you've proved there is that a 45-character string can't ever be longer than 45 characters. Try adding PRINT @STR1 and you'll see that the string has lost the...

No, the last...

You can't rename a PERSISTED computed column, too!

Why?

I poke the wrong answer, but I learned something new.

Thanks.

😀

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:...