The DB is in FULL recovery, the table gets hit at least 5-10 times a minute with writes and reads

Why not use SSIS to send the data across?

Yes they are teamed, one can transfer only and the other can transfer and receive. Both seem to be running fine with no faults.

bugg (10/12/2013)

---

Perry Whittle (10/12/2013)

---

Although they are next to each other, they presumbaly plug into a network...

Perry Whittle (10/12/2013)

---

Although they are next to each other, they presumbaly plug into a network switch,...

ScottPletcher (9/16/2013)

---

Just as a possibility: Check constraints instead will reduce overhead slightly, since another table doesn't have to accessed. For a very limited number of known and easily recognized...

Thanks batgirl 😉

Awesome guys thanks the responses, just needed some confirmation that was the way to go , cheers

D

I think you'll have to change the name columns (name1, name 2 etc) in the SOURCE to rows

So your SOURCE would be

using (

SELECT t2.id,t2.name1 as name FROM table2

UNION ALL

SELECT...

No worries, found this article http://blogs.msdn.com/b/psssql/archive/2012/09/01/installing-sql-server-on-windows-8.aspx 🙂

I found the issue the join in the TARGET on sku and giftsku was slowing it down.

I changed the joining column and it...

vultar (7/19/2013)

---

How many rows are in the data sets being merged ?

I guessing the population of the cache is taking the additional 8 seconds, especially if the query usually runs...

Below is my code, is there anyway i can keep the MERGE but improve the delete performance? Is there a better alternative approach to doing a MERGE?

BEGIN TRY

BEGIN TRANSACTION

;WITH...

Hi Guys, I will post my code on Monday. After reading that very informative post i do think I may have to go with a separate delete option.:unsure:

Thanks for that link having a good read