We're human beings. Our tendency is to gather until we can't.

5000 days...

Would have been even better if he didn't give any points for any answers. Then the...

Sean Lange (4/2/2012)

---

There was a spam message in here at one point. After he reported it they took down that...

Evil Kraig F (4/2/2012)

---

GSquared (4/2/2012)

---

GilaMonster (4/2/2012)

---

Evil Kraig F (3/30/2012)

---

GilaMonster (3/30/2012)

---

I read the end of that and I am not getting involved...

Initial gut feel - improper transaction management (leaves transactions open)...

Side note, potentially even better than scope_identity() is using an Output clause in the insert. That can handle multi-row inserts, can't cross-scope, and allows for options other than just...

GilaMonster (4/2/2012)

---

Evil Kraig F (3/30/2012)

---

GilaMonster (3/30/2012)

---

I read the end of that and I am not getting involved...

Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling....

Identity columns don't guarantee sequentiality. They can skip around. If an insert fails, or gets rolled back, the identity goes up, but the row won't be in there.

Since it happens under heavy load, is it possible the DAL (or application if you aren't using an explicit DAL) is dropping connections before allowing the transaction to commit? ...

I must be missing something. What spam?

Revenant (4/2/2012)

---

GSquared (4/2/2012)

---

As usual, I spent the day telling people who were barefoot or in sandles, et al, that their shoes were untied. Told my dogs that too, of...

As usual, I spent the day telling people who were barefoot or in sandles, et al, that their shoes were untied. Told my dogs that too, of course.

Put white...

opc.three (3/30/2012)

---

That's an awesome list, but we do not even know the type of DBA role we're talking about here. Level 1 / Level 2 / Level 3 DBA that...

I've been using Ignite for a couple of years now, and consider it a great tool.

For example, when I first started using it, we had a situation where a code...

It's all a question of Union All and columns to control order and section. You can add as many sub-totals/grand-totals/summaries as you like, interspersed with the main data, by...