Good question, didn't know about the limits of an INSERT, good to learn, though I think it is not that often used in production.

SQLDCH,

Is there still a chance? Looks like someone hasn't registered his/her team.

roryp 96873 (8/22/2012)

---

Well, it looks like we are only about a week and half from the draft and we have an...

I haven't worked with Kerberos authentication, so I had to look it up. Interesting to learn.

Nice question, learned something new today. I was quite sure the answer would be 251, but then I remembered data type precedence may be tricky.

Toreador (8/21/2012)

---

sestell1 (8/21/2012)

---

Implicit conversion isn't always...

Nice and easy question to start the week.

I was told once before (by an Oracle DBA) that using COUNT(*) was not a recommended practice as it would cause performance issues...

Good question, didn't have the time to investigate in BOL, so I took a guess and got it right.

Happy weekend everyone!!

Great question. Learned something new, now I have to remember that the next time I use table variables.

Thank you for the easy question.

Enjoy, Tom.

SQLRNNR (8/14/2012)

---

Why are there braille dots on a drive-through ATM...

Free!!!

Link 1

Link 2

L' Eomot Inversé (8/14/2012)

---

Hugo Kornelis (8/14/2012)

---

WayneS (8/14/2012)

---

One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about...

Is there still a chance to join?

Fragile.