Are you sure the data is the same between the servers? ORDER BY should work the same way, regardless of NULL values. Maybe the databases have different collation settings? That...

You should look at the OUTPUT clause. You can use that to capture the ID's generated for all the addresses you just inserted.

You need to determine what "locked up" means. It could be that the procedure recompiled with a bad plan and the queries are running slow, or it could be contention....

Stefan Krzywicki (8/3/2010)

---

Grant Fritchey (8/3/2010)

---

Stefan Krzywicki (8/3/2010)

---

Brandie Tarvin (8/3/2010)

---

Light show?

The Northern Lights or meteor...

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people screaming about...

Stefan Krzywicki (8/3/2010)

---

Meteor shower. Scroll down...

Ditto. We'll be out at a Scout event. It'll...

DB_Newbie2007 (8/3/2010)

---

Thanks for the comments, Grant.

The cost threshold for parallelism option on this server is set to 5.

Window Server 2008 Standard (64-bit).

SQL Server 2008 Standard (64-bit), Version...

Stefan, good thought on the optimizer dropping out, but both queries went through a FULL optimization process. That means the optimizer thought it had them both right. I'm still wondering...

Steve Jones - Editor (8/3/2010)

---

Not to make it too much of an issue, but in the US we have fundamentally tried to give freedom to religious institutions. For better or...

Stefan Krzywicki (8/3/2010)

---

WayneS (8/3/2010)

---

Stefan Krzywicki (8/3/2010)

---

WayneS (8/3/2010)

---

There's a quote in this article that sums up my feelings:

"On the...

DB_Newbie2007 (8/3/2010)

---

Grant,

Unfortunately, "ChargeType" is actually my name for a bunch of columns added together in this particular table to list a charge. The tables (dbo.Jan10, dbo.Feb10, etc) are wide...

DB_Newbie2007 (8/3/2010)

---

Grant,

I agree with the previous statement (RIGHT(RTRIM(InvoiceNumber),12) is a performance issue)... the VIEW_InvoiceData table was never intended to be queried against. Unfortunately, the original architect (2007) did not...

Personally, I have zero issues with a mosque near Ground Zero. But... that particular organization has an agenda...

The faster query is getting a parallel execution (assuming I'm reading which of the two plans is the faster). That could explain the difference in execution times right there. But...