Place I used to work at just had similar issue when they moved to new server.

Sounded like network traffic was the issue.

Ed Wagner (1/30/2014)

---

Jeff Moden (1/30/2014)

---

rodjkidd (1/30/2014)

---

Company has out sourced prod DBA team. Been up and running since start of year, so some things are still falling through the cracks. So...

rodjkidd (1/30/2014)

---

HowardW (1/30/2014)

---

Jeff Moden (1/30/2014)

---

rodjkidd (1/30/2014)

---

Serious Doh! Moment today.

... {snip}...

Went to talk to one of the Prod DBA's as my access on the server is limited, and he spots that...

GilaMonster (1/27/2014)

---

Abu Dina (1/27/2014)

---

It's really about finding duplicate entries within the record set. A duplicate in this case is at site/business level.

Same company same address = duplicate

No company but with...

crazy_new (1/29/2014)

---

The end user would insert all the details before the invoice is created, when he creates a preview the invoice show up on the screen with an invoice number...

Jack Corbett (1/29/2014)

---

The weather here in New England has been odd this winter. We'll have a decent sized snow storm roll through (6+ inches), then we'll warm...

rodjkidd (1/29/2014)

---

As we are talking weather... Don't think I've mentioned this before...

We have a off shore team working on site. They go back to India in a month or so....

Lowell (1/29/2014)

---

Greg Edwards-268690 (1/29/2014)[hr

Wouldn't an Exception Join (NOT EXSISTS) actually be better?

Although a real gap could also be record updated.

Or maybe that never happens. 😀

Bottom line - spend the...

GilaMonster (1/29/2014)

---

Ed Wagner (1/29/2014)

---

That sounds seriously unpleasant -...

Lowell (1/29/2014)

---

why not just create a procedure that finds what has not been migrated yet?

either via a join so that it is a perfect match, but probably resource intensive, or...

Ed Wagner (1/29/2014)

---

Greg Edwards-268690 (1/29/2014)

---

rodjkidd (1/29/2014)

---

Talking of Grant, did anyone see the picture of him on the SQLCruise yesterday- almost as red as the livery of that company he works...

crazy_new (1/29/2014)

---

There are multiple line in the Invoice line table with the same ID, that's why I joined the Invoice ID and Invoice header.

I have to move them across from...

Bring him to the...

Similar to Lowell and Gail, just worded a bit differently.

Do Invoice Lines exist before the Invoice Header is inserted?

Is there ever more than 1 Invoice Line per Invoice Header?

Same question...

GilaMonster (1/28/2014)

---

Greg Edwards-268690 (1/28/2014)

---

GilaMonster (1/28/2014)

---

Anyone got time and enthusiasm? (running low on the latter and it's almost time to go home)

A trigger that doesn't work: http://www.sqlservercentral.com/Forums/Topic1532595-1292-1.aspx

An IF statement that, well,...