Thanks Paul. I am confused about #1; doesn't it need an explicit rollback statement to be executed?

@Gail: The log size is about 5G on disk. I apologize, should have given...

@Gail: I considered log backup but the monkey wrench is that we have 1 nightly full back up and hourly txn file backup. My DMV would have reported low #...

Thanks for the response Jon, yep missed that ... the interesting part is our devs are cowboys dont have any transaction scoping in our code ... definitely a curve ball.

Jacek's article was debate worthy. I believe he and I don't see eye to eye on the evaluation approach .... he...

Tommy,

Which part of my response said...

On the contrary, in combination w/ avg reads, avg writes, and avg CPU this information can tell a very good story. The point being that ClearTrace like any commercial product...

Sad isn't it when my forum posts offer more challenge and value .....

cheer,

tpoulsen (12/1/2009)

---

Well don't read it then - the only thing that's worse than low quality forum posts is people poncing about complaining about how offended their intellect is by this...

Yes it is ...

1. If you are using...

Heh... man... you don't need be to be so rude. Most everything that folks write an article having to do with SQL Server are all "age old dilemma's" and yet...

Yes but there is nothing fantastic about your method; its been long done by many in SQL2K world. Just google and you will find a ton articles ...

cheers.

Seth,

this is an age old dilemma and was put to rest with many variations like JP de Jong-202059 pointed out. In fact this site has articles with script to perform...

JacekO,

No offense, but you are wasting too much time on worthless reporting. If I were you, I would just use ClearTrace to read the trace results. It analyzes based on...

Jeff,

Thanks for your response. Actually, this question is very common when you are an ISV. This question comes with a lot of merit. As a part of any ISV implementation,...

Come on; such simple solutions are expected out of novice heads me not brilliant minds like you .... 🙂

Changing compatibility is not an option in most cases especially when you...