magarity kerns (8/15/2008)

---

By the most amazing coincidence, we have just discovered a developer's query is running out of tempdb space because of the following as his join clause:

where

a.acct_nbr >...

Joe Celko (8/15/2008)

---

Very nice explanation of the problem!

Right now, I'd do running totals in a report writer with SQL Server. But my current job uses DB2, so...

toniupstny (8/15/2008)

---

(** adding: in response to Charles **)

Hmmm.... I (re)read the article Jeff pointed to as the follow-up

and frankly did...

Thanks Ed... the followup is at the following URL...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Heh... no... just surprizes... 😉

toniupstny (8/15/2008)

---

I am not sure if this was covered somewhere in the numerous prior pages of discussion as I had a hard time going through all of them (pardon me...

Actually, in the Running Total...

Thanks for the feedback, David.

I'm such a dummy... to do this in almost a single click, I just need to turn of the SQL Server Agent and turn it back on when I'm done....

No, no... the deleted rows aren't a problem... my appologies for not being a bit more clear (pretty much under the gun and not thinking correctly). The rows are...

I think I've got this... I'd have to disable all 70 Log Reader Agents... and then turn on just the ones that were previously disabled. Sounds like a real...

Oh yeah... almost forgot... the reason why I don't do the copy, delete, and rename thingy is because I don't know if it'll break replication or any of the associated...

rbarryyoung (8/14/2008)

---

OK, there are several places that you can do this from, but the best place is: "Replication Monitor/Agents/Log Reader Agent" which will all of the LogReaders and only the...

Oh hell no! 🙂 I'm not a "systems" type of DBA and I've never used replication before. I'm one of them...

Ok... thanks Gail. And, heh... thanks for not killing the OP for his ignorance in this area. 🙂