As a matter of preference as well as having seen substantial performance gains, I avoid the use of subqueries and use Join statements as well as CTE's. Moving subqueries...

The provided script will get you to the point of being able to merge the data. You will need to decide which record in the database to update with...

Nice, I like it better than some of the comma split functions I have seen.

What have you seen this scale out to?

For curiosity sake, I decided to see what kind...

bpowers (12/7/2009)

---

This updated all the records regardless of dates. What am I doing wrong?

UPDATE CUST_LINE_DEL SET USER_ORDER_QTY = '9'

FROM CUST_LINE_DEL

JOIN CUST_ORDER_LINE ON CUST_LINE_DEL.CUST_ORDER_ID = CUST_ORDER_LINE.CUST_ORDER_ID

JOIN CUSTOMER_ORDER ON CUST_ORDER_LINE.CUST_ORDER_ID...

I agree with Andrew here. There is at least one table causing your results to grow. Narrow it down as Andrew explained and work on the select statement...

BTW, thanks for posting that information.

The tsql to change the parameterization is:

ALTER DATABASE [TestC] SET PARAMETERIZATION FORCED

GO

Ah now I see what the issue is.

I was able to get both to use the same execution plan by changing the Parameterization option in TestC db to 'Forced'

In the...

Now that I read the rest of the thread - after my last post - it seems a bit late.

Happy Birthday again anyway.

Good thing I got it in there before you posted Birthday.

And if it is your birthday - Have a Happy Birthday.

Very accurately depicted

DBADave (12/7/2009)

---

Yes. One 250GB clustered index. It's a financial system used in the trading industry so we have no control over the design.

SORT_IN_TEMPDB is used, but...

I would let it run to completion if at all possible.

I think you will find that the advice given by the experts here has been generous.

Many of the people that have responded to you post are Interviewers and influential in...

GilaMonster (12/7/2009)

---

CirquedeSQLeil (12/7/2009)

---

GilaMonster (12/7/2009)

---

Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too...

DBADave (12/7/2009)

---

What software and/or processes do people follow when reindexing a 250GB+ index? When our weekend reindex job runs against a 750GB+ database it generates 500GB+ of changed data...