Sad more than anything. Can't believe someone could take so much time working out a solution that already exists in...

What are you using to execute the stored procedure? Is this part of a job or an application? Curious.

Jeff - I am wondering why you are considering using Read Committed Snapshot. Any chance you could share your thoughts behind this?

Thanks in advance.

Another note on this too, at the end of the blog post Bob mentions the potential for too many VLF's in the log file and that may be true and...

A great article on this, albeit a bit late, from Bob Dorr can be found HERE. Might be worthwhile to read so that you can speak intelligently about the recovery...

The lumigent tool that you would want to look at it called AuditDB and can be found at this LINK. Having had to support both SOX and HIPAA, that product...

My guess is that this is due to the way the sp_MSForeachdb actually works in that it runs the statement in the database then moves on with each statement execution...

One important note, and I believe that Kim expresses this, partitioning is not necessarily the answer to performance. It can be a great improvement in performance for those areas where...

A great place to start would be this article from Kim Tripp.

Hope this is helpful.

free_mascot (2/12/2009)

---

Still there are lost of new features are there which DBA can target. eg. high availability like mirroring, Snapshot, service broker, clr intigrity, xml and much more etc....

I feel...

Naw, I just script anyway. 🙂

I am, uh, um, not sure what to make of that. All I can say is ouch.

Click on My Account in the upper left hand side and then click on the change my email address.

Hope that works.

Yeah, just noticed you today too. Funny. I think...

GilaMonster (2/10/2009)

---

If you want to laugh...