Wow... lots of posts about this.

I understandthe Author wanted us to realize that no matter what your TSQL is, when you display an execution plan at least one...

Still not clear if you enabled the registry setting and other items recomended in the article. They are not service pack specific.

Check your cluster server IP and Port settings.

This...

Did you try any of the items in this article?

http://support.microsoft.com/kb/307197

L' Eomot Inversé (1/5/2013)

---

Yes, of course attempting to insert a duplicate will fail, that's the whole...

Toreador (1/4/2013)

---

I don't really like this question.

"They are not the same, but they both enforce uniqueness of the column on which they are defined"

assumes that they can both only...

SQLRNNR (1/3/2013)

---

dineshbabus (1/3/2013)

---

I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that will allow...

L' Eomot Inversé (1/2/2013)

---

It would be a good question if it specified that the queries were run using SSMS with a default install and no user changes to configuration options.......

Nice question with a good use of the new 2012 Adventure Works database.

bitbucket-25253 (12/28/2012)

---

I thought the...

+1

Great question.

Hugo Kornelis (12/21/2012)

---

My point is also not that I want the current implementation of UNIQUE removed from the product.

My point is that IF a feature is implemented that has the...

Lots of posts and comments but none of them, including the answer code, shows a UNIQUE CONSTRAINT on a TABLE column that allows more than one NULL value.

A...

Hugo Kornelis (12/26/2012)

---

SanDroid (12/26/2012)

---

Hugo, Great question that realy made me think.

However part of your explination seems incomplete or missleading.

If statements and other control flow language create new batches,...

Post was removed cause poster did not understand the difference of values returned by NULLIF and ISNULL.