I dont' think it's a limitation in the MERGE statement itself. It's just that the optimizer decided to implement yours in an inefficient way.

Actually, anti-joins are often a pain, not...

Also, the plans don't look very similar.

The DELETE plan is way different. It's a parallel plan, while the MERGE plan is serial. There's a hash match and... it's a...

OK, looking at your code, looks like you're trying to do everything in a single pass (which is often a good idea).

In this case, you're using the WHEN NOT MATCHED...

David Moutray (6/21/2013)

---

Nothing? :w00t: I was sure that one of those brilliant SQL veterans like Gail Shaw, Jeff Moden, Grant Fritchey, Steve Jones or Adam Machanic would have...

Thanks a lot, Johan.

It's amazing how time passes: it was first published three years ago!

Troubleshoot the obvious first: use portqry to test if the server is reachable from the remote machine. If not, something (firewall) is filtering the traffic.

Ha! I tend to look at things inside the RDBMS first, while the problem could actually lie somewhere else. My bad.

Glad you sorted it out.

Cheers

Gianluca

I would start looking into sys.dm_exec_query_stats to find the queries that are not behaving as normal per your baseline.

Queries that use a lot of memory must be reading lots of...

I really like the UI! I had never seen it before, thanks for sharing.

That said, the forum sw here needs some improvements and probably it's more convenient adopting a ready-mad...

System databases can get corrupted just as user databases.

In case of corruption, you'll need a backup copy if you don't want to install from scratch.

L' Eomot Inversé (1/22/2013)

---

SQLRNNR (1/21/2013)

---

Gianluca Sartori (1/21/2013)

---

On a totally unrelated note, what do you think of this person?

He's coming to Italy and my UserGroup is thinking about organising an event....

Dave Morris (1/23/2013)

---

In the cursor SELECT statement I've added single quotes to the NAME column as the instance has some databases that have spaces included in the names. This made...

Great article, Erin.

Also, lots of useful code in there.

Thanks for sharing.

Johan, you...

SQLRNNR (1/21/2013)

---

Gianluca Sartori (1/21/2013)

---

SQLRNNR (1/21/2013)

---

Gianluca Sartori (1/21/2013)

---

On a totally unrelated note, what do you think of this person?

He's coming to Italy and my UserGroup is thinking about organising an event....

SQLRNNR (1/21/2013)

---

Gianluca Sartori (1/21/2013)

---

On a totally unrelated note, what do you think of this person?

He's coming to Italy and my UserGroup is thinking about organising an event.

Would you pay...