Glad I could help. 🙂

Jeff Moden (2/21/2010)

---

Very cool set of links, Barry. Great blog site on your part, as well! Other than the awesome content (haven't explored it all, yet, of course)...

Paul White (2/21/2010)

---

...

Personally, I doubt the query is disk-bound; it is more likely that the rewrite introduced a spool of some kind, or is using a kind of join which...

While I don't know why the OP does it this...

Some things are pretty hard without it. For...

There are two secrets:

First is the [ code="sql" ] tags. Like this:

SELECT * FROM YourTable

The second is the [Quote] button above every post. Whenever you see a cool...

Set your database to TRUSTWORTHY.

(also, please be aware that this has security implications).

Sander A. (2/20/2010)

---

I'm trying to tune a big query.

The starting point is a query with a query cost of 4.2, CPU time 4 seconds, execution time 6 seconds. After...

Welsh: Just an FYI, but "FOR XML EXPLICIT" should always be a last resort for XML construction,...

Lynn Pettis (2/20/2010)

---

RBarryYoung (2/20/2010)

---

Lynn Pettis (2/18/2010)

---

Barry is another one that I would be quite happy for should he become a MVP. He's done a lot as well and deserves...

Also there's no Primary Key on InventReorder.

FYI: @PartDescription is not defined.

OK, given all that, ... Why the Loop? You can do everything that you mentioned above, but generate set-oriented SQL, instead of scalar & loop-based SQL. I know...

Thanks, Lynn....

"Shoot, Aim, Ready." Heh. Not a best practice for DB Corruption and Recovery.