Thanks Solomon for a great article and I agree this is a great topic. Here at my company we have very large databases and an application that is required...

The question clearly stated which ones work 'regardless of any date format or...

I agree, it is hard question and a very good one. Thanks.

A very good question. It is unfortunate that some are not getting the message that it is trying to convey, that not all date formats are portable across all...

Hey, April Fools was LAST Friday!

Great question. Love the title.

bitbucket-25253 (3/30/2011)

---

So if I did apply the correct answer I could not create the additional indexes due to the error of attempting to create a "duplicate" index?

Not sure if I...

For reasons already stated, I wasn't sure how to go on this one? So I guessed that the author thought that the create view syntax was correct which...

Duncan Pryde (3/25/2011)

---

Thanks for the question. Reading the article, I now understand RAID 2, 3 and 4 as well.

But won't we all be using ZFS in a few years anyway?...

Interesting, I did not realize that the Table Value Constructor behaved like a UNION. It makes sense now that it has been pointed out.

Surii (3/18/2011)

---

Chris Houghton (3/18/2011)

---

I'm half asleep this morning. Missed every one of the potential gotchas (implict conversion, US date format and extra comma), thought "this code looks ok" and...

A lot going on in this question with the superfluous comma, reserved word usage and implicit conversions but interesting question, thanks.

This is useful information, thanks for the question.

Just don't forget to put the GO at the end, otherwise when you put it into an upgrade script you never know what you are going to get.

Great question, thanks.