Check out this thread for an alternative method at helping to figure out what caused tempdb growth.

Opentran will work great - if the transaction is still running.

Is your com+ service running in services.msc?

Check this out - should give you an idea of how to use the command.

http://msdn.microsoft.com/en-us/library/ms189493(SQL.90).aspx

I have never encountered any of these issues outlined in the reference articles. Thus, we have never pursued disabling the chimney. Since we still don't experience the problems,...

Thanks for the article. Nice idea and well written.

jcrawf02 (1/25/2010)

---

CirquedeSQLeil (1/25/2010)

---

jcrawf02 (1/25/2010)

---

So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?

Clouds push complexity to the background and allow users to focus...

Thanks bitbucket for providing yet another QoTD.

jcrawf02 (1/25/2010)

---

So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?

Clouds push complexity to the background and allow users to focus on what...

Nope. Try the turbo button.

i would keep looking at it. I can't imagine a weekly update stats job bloating your database like that all by itself....

crookj (1/25/2010)

---

CirquedeSQLeil (1/23/2010)

---

D.Oc (1/23/2010)

---

CirquedeSQLeil (1/23/2010)

---

There's a lot more than just teeth that your lions don't have...

for all the threadheads - some may have noticed already, I have created a twitter account (sqlrnnr). I will probably write a blog post about the reasons why real...

Thanks Gail - now that is really useful. 😀

For what it's worth, I don't use Hungarian notation - unless in OO languages (do it there since it seems to be a common practice). I prefer to keep...

Thanks for the article discussing this product from MS. PriceTag is hefty - and to some would only be pocketchange. Difficult price to manage for some. Then...