Completely no help to you, this is a great example of how the estimated costs and the actual costs have nothing to do with each other. Jeff would love it.

Looking at it some more, you're query is joining between tables with this:

JOIN dbo.Citizenships AS C

...

That's a strange one. The estimated & actual rows are WAY off. You might check the statistics. Let me keep looking.

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...