Really. When did it occur? When the query had to hit lots of the partitions or is it just a...

Oh no, if it's going to bug the apps, then clearly the data is not guaranteed unique. I'm just saying if the data is going to be unique, there's no...

Lynn Pettis (2/6/2009)

---

The more you remind me of what my brother said about the Navy, the more I'm...

Yeah, that's pretty much my understanding too. Better & more memory management in the 64bit operating system, which benefits SQL Server.

I don't know where you heard that it's 32-bit only...

It depends on the queries being run. The optimizer will take into account when an index is unique and it can improve performance, but it really does depend on the...

I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).

GilaMonster (2/6/2009)

---

Indeed, and by too many indexes, we're not talking 2 or 3 here. It'll take more than that to cause a serious slowdown of the inserts. If one index...

GilaMonster (2/6/2009)

---

Indeed, and by too many indexes, we're not talking 2 or 3 here. It'll take more than that to cause a serious slowdown of the inserts. If one index...

Lynn Pettis (2/6/2009)

---

Grant Fritchey (2/6/2009)

---

Lynn Pettis (2/6/2009)

---

Being prior enlisted in the Air Force, I guess it depends on who you hang out around. I've met a few that would...

Chris Morris (2/6/2009)

---

Grant Fritchey (2/6/2009)

---

Oh there are individuals, but the culture seems different. The Air Force bases were always so clean & orderly & mannered where as, except for boot...

Lynn Pettis (2/6/2009)

---

Being prior enlisted in the Air Force, I guess it depends on who you hang out around. I've met a few that would turn a Marine "Air...

Lynn Pettis (2/6/2009)

---

Grant Fritchey (2/6/2009)

---

I speak a bit of Southern, some Jersey, some Brooklyn. I'm very fluent in Navy, but really, it's just English with the f-bomb inserted every three...

Oh, you want to verify that they have BOTH values, but if they have one or the other, it's no good to you?

OK then, how about joining to the table...

I speak a bit of Southern, some Jersey, some Brooklyn. I'm very fluent in Navy, but really, it's just English with the f-bomb inserted every three to four words.

How about using an OR statement between the two criteria?