Good one, Steve, thank you for the post.

(initially.. all he choices were seems to right, after reading each one very very carefully.. was able to select the correct one)

.. you mean, the auto insert?

Good one, Andy, thank you for the post.

I got tricked by first two options, and I did not select the first one and selected the other feasible two. Even though...

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned....

Thank you for post, SJ, simply nice.

Thank you the post, SJ, simple one and nice.... but I did get it wrong.

I opened the LFV and saw these (with sub selection under each, except agent) "SQL Server",...

Thank for the post, very interesting one.

(Out of 4, I got 2 correct, but learnt a lot today) 🙂

Hugo Kornelis (5/20/2014)

---

I decided to run a quick experiment to see if I could find any limits. Here is the code I used to create a table with lots of...

TomThomson (5/20/2014)

---

Good shooting, Hugo1 🙂 I was too lazy to experiment :blush:, so I'm glad to see your results.

edit: "Hugo1"! My left little finger has failed me...

Thank you for the post, Andy, interesting one.

"If 249 and 999 sound familiar those have been the limits on the number of indexes, not foreign keys making those answers incorrect,"......

Thank you for the post, free_mascot, good one.

Actually in real I have no idea how this works, probably wouldn't get a chance to see it... but on the bright side...

Thank you for the post, SJ, interesting one.

Learnt something new, and then learnt what I learnt is not correct and then I learnt the correct way. Also voted on the...

Awesome, this was really cool post. I narrowed down to 2 and 6, and then was thinking if the db was offline then how server will access it... then with...

Thank you for the post, ST, very very interesting one.

(As I am using this feature for the first time, I just created a FT and was looking in to the...

Andy Warren (5/12/2014)

---

Stephen, writing the QOTD is a lot of fun. Not easy, but fun. I've got a bunch of posts on the lessons learned/tried so far at http://sqlandy.com/tag/question-of-the-day/ that...