Matt Miller (#4) (2/23/2010)

---

- You could batch them into a single XML document and process that inside SQL using SQLXML.

- you could look at using SQL Service Broker. ...

There is. ...

Elliott W (2/23/2010)

---

I think RBarryYoung is on the right track, what you are describing isn't so much as blocking or locking but that other queries are fighting to just complete....

Paul White (2/23/2010)

---

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come...

Gianluca Sartori (2/23/2010)

---

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come...

Paul White (2/22/2010)

---

Well I don't know exactly what the criteria are, but Barry strikes me as a...

Paul White (2/22/2010)

---

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come...

Paul White (2/22/2010)

---

Steve Jones - Editor (2/22/2010)

---

You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.

Be...

WayneS (2/22/2010)

---

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no...

Well, I did read them,...

Not true, sets can have order, they're called "ordered sets" and they've been around for many decades at least (Church in the 30's, I...

OK, thanks for the c code. It looks OK, other than the whole "one at a time" issue that you and Matt are are already talking about, because its...

In general, since you do not know who is doing this, you should not yet try to analyze the permissions and rights of the situation.

Rather, I think that you should...

The only time I have seen something like this happen, was when the application DBAs where restoring test scenario DB backups over the existing databases, without telling us SQL Server...

Please post your c# code that is doing the Insert.