Since these are implemented as an inverted b-tree, one could argue that the correct answer is [1]. 😛

I concur... but what is easy for one person isn't for another.

Awesome Gail. Major congratulations!

IMO, another valid answer to this question is "Clustered OR nonclustered index, depending on the specification of other constraints". Tying in with the building a unique constraint on the FK...

Ron - thanks for the question.

All others: Ron (aka bitbucket) has contributed ~ 75 QotD questions, and this is the first one that I've seen from him with this level...

bkmsmith (6/25/2012)

---

sestell1 (6/25/2012)

---

mtassin (6/25/2012)

---

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what...

jeff.mason (6/23/2012)

---

You cannot define indexes at object creation. And while a typical table will create an index for a primary key, I suspect that this does not happen for...

Good question Koen... I didn't know it only supported a limited set of versions. Thanks.

craig.watson (5/15/2012)

---

Thanks for the post Wayne, I will point all developers of convoluted datetime function hacks to this article for education.

I always find simplicity in code to be a beautiful...

Great article Jeff.

One thing to mention... in the article, you pointed out that you cannot directly add / subtract a number to the new DATE data time. This applies to...

Good question, thanks! It's always nice to brush up on things.

Great article Jeff.

Awesome discussion by all! Thanks!

Lynn Pettis (7/1/2012)

---

WayneS (7/1/2012)

---

Lynn Pettis (6/26/2012)

---

Mandatory evacuation area has expanded on the North West side of Colorado Springs. The area now includes the area where I currently work.

Waiting for...

Lynn Pettis (6/26/2012)

---

Mandatory evacuation area has expanded on the North West side of Colorado Springs. The area now includes the area where I currently work.

Waiting for email updates to...

I'm curious about what is being done to ensure that something like this doesn't happen again?

They...