Not true! Exam format can change, but format itself can be public...

Thanks for reply though

Like an 1 hr or so.

Unfortunately , I can not post the code here (data privacy and all that stuff) and honestly, I do not want to dig in...

GSquared (1/27/2010)

---

Are you saying that if you clear the buffers, the proc takes seconds to run the first time, and then keeps going that way?

I've never seen that behavior. ...

I recieved this db from a former dba and I overlooked the Tlog size. It was ridiculous small. About 1gb for a 80 GB database; the small size was aborting...

Ran the DBCC CHECKDB, and nothing, no errors ..

I tried to run the DBCC shrinkfile again, and failed. This time I ran a Tlog backup prior execution.

any ideas?