There is nothing in the Wait Type field when I view the block through Activity Monitor.

Not sure how to speed up the query though.

Bob Griffin (5/5/2009)

---

Sounds like the manager doesn't know what he/she wants. I would use this as an opportunity to control your own destiny. You decide what numbers to...

I was (correctly) apprehensive about posting such an open-ended question. Molasses flow is hilarious; I deserved that one.

My post is indicative of how desperate I am to learn what others...

Is this the BOL reference:

http://msdn.microsoft.com/en-us/library/ms174378.aspx

did you run into a problem; I have used this a couple of times without any adverse effects.