Two questions in one, EJ, just an FYI. 🙂

First, you need to compare one row to the previous row. This is usually done via a CTE with a ROW_NUMBER()...

Rog Saber (11/22/2010)

---

I wrote an after update trigger on Table A. When I tab off of the field I changed to see if the trigger worked, I get the following...

My first instinct is that you're looking to do administrative level tasks. Are all servers in house to your company, or is the target SQL Server an...

Grant, what about the option of using PAGELOCK as a table hint during the delete? If it's clustered on the ID, that'll keep it out of the way of...

Dominic,

I'm sorry that this is an untested recommendation, but I believe DBCC CHECKIDENT can be used to change the seed on a replicated table if the identity is set for...

In addition to GSquared's recommendation, which I'd check first...

Are the result sets large-ish (say 10k rows each or more?) independently? Are you doing more with the UNION ALL than...

This is most likely the problem. There was most likely changes to the source db between the time you made the copy...

pavan_srirangam (11/22/2010)

---

thanks any way

one last question

If I add more .ndf files to the database will reduce pagelatch_up waits and resource is 5:1:3 no.

Because I found there are...

da-zero (11/22/2010)

---

Craig Farrell (11/22/2010)

---

The other option is using the expressions in the OLEDB source object, and setting servername via the variable, then using that as the source for a dataflow...

I came across a tragedy like this only once. I forced a redesign...

The other option is using the expressions in the OLEDB source object, and setting servername via the variable, then using that as the source for a dataflow pair.

Removed, inaccurate.

WayneS (11/22/2010)

---

Stefan Krzywicki (11/22/2010)

---

Brandie Tarvin (11/22/2010)

---

Chris Morris-439714 (11/22/2010)

---

CirquedeSQLeil (11/22/2010)

---

Did I miss something more than...

Not declaring the name ends up with a system defined one. It's usually used for Temp tables and the like to avoid conflicting names when the proc is run...

CirquedeSQLeil (11/20/2010)

---

Craig Farrell (11/19/2010)

---

WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

WayneS (11/19/2010)

---

Craig Farrell (11/19/2010)

---

Wayne, Lutz and I are volunteering you for Larry. Well, I am, Lutz isn't convinced your current avatar is less appropriate....