Mojito

Profligate

Actually a FULL OUTER JOIN is probably going to perform better. I believe that article says as much.

At the last PASS summit, I had a chance to talk for about an hour at breakfast with a man from Microsoft who is part of the BOL team. ...

Gail, are you saying the posted questions are getting worse?

The response was rude, insulting, and totally inappropriate. It earned the OP a spot on my personal blacklist.

I got it wrong. I answered "purple". :doze:

And we all know that the "B" in "B-Tree" as defined by Microsoft, means balanced, and not binary. Right?

A thought provoking question anyway....

I think "unique" should count twice or not at all. You can have unique clustered indexes and unique nonclustered indexes.

You are trying to join on characters in the middle of a string. There is no way for an index to help with a join that vague....

Understanding and applying Paul White

Priapism

My wife had an interesting thought about plagiarism, which was that websites should NOT take down those articles. Instead they should keep the title, the name of the...

Tom.Thomson (5/11/2010)

---

Cliff Jones (5/6/2010)

---

What threw me off was "All nonclustered indexes include the clustered index columns in their index pages" . I thought this was incorrect because the clustered...

Well said, and too true, Grant. The discussion has been interesting too.

Forums really shouldn't be a resource of last resort, especially in an emergency. A forum is...