Mike Dougherty-384281 (4/17/2013)

---

Hugo Kornelis (4/17/2013)

---

Good question. Not perfect, though.

longer answer options - and especially the inclusion of three of the returned values for the "yes" option. Technically, this makes both...

demonfox (4/11/2013)

---

jlennartz (4/11/2013)

---

If default values are returned as in your explaination why are not all the values except null returned in this format, "1900-01-01 00:00:00.0000000". How did...

If default values are returned as in your explaination why are not all the values except null returned in this format, "1900-01-01 00:00:00.0000000". How did they get...

Thanks You for the nice clear question and answer.

cdonlan 18448 (3/15/2013)

---

Lynn Pettis (3/15/2013)

---

Same things I would have said to you in person.

I'm not the one calling someone...

I think we got off track in an area Steve said to avoid. He specifically said to

"Please avoid political or socials issues and stick to something in...

choose 4 of the 5 right answers but not the right answers because no where in the stated documentation does it discuss the creation of indexes but both talk about...

Another learning Experience. Thanks for the discussion, It always helps clear up misunderstandings.

john.arnott (11/2/2012)

---

jlennartz (10/31/2012)

---

Not sure what real world value this question would be as it does not keep the sales attached to the correct UserName and UserID. Seems...

Not sure what real world value this question would be as it does not keep the sales attached to the correct UserName and UserID. Seems like you...

Why wouldn't all selects error out as in the example in MS189491 when the set dateformat's used both end with year but all the dates start with the year?

sknox (2/10/2012)

---

Hugo Kornelis (2/10/2012)

---

I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did...

cengland0 (2/3/2012)

---

I learn much more through the QOTD discussions than...

Glad I came in late and found the correct answer there.:hehe:

Good question as it led to alot of interesting discussion which is usually the most interesting part of the QoTD's.

Just to add another twist to the phrasing...