Good thing John doesn't work for Jeff 😉

Your question is too open ended. Go read the index section in Books Online and then come back with more specific questions.

They are probably based on the plan contents or possibly could these be master/target plans? Maybe one's a subplan?

Is there something different about the plans?

I've had linked servers flake like this in 2000, but haven't seen it in 2005 (much less experience also).

What type of server is this? I've seen issues with DB2 where...

Enterprise Manager/ SQL Server logs shows the instance error log. NOT the transaction logs.

Log Rescue reads logs from the transaction logs. I'll have to pass your question along as I'm...

The text/image types put stuff in separate extents by default. You can change with the text in row option and if you do, I don't think there's a difference with...

If I remember right, it was about 35-37 questions, multiple choice and then 10-15 simulations.

It's possible that other activity was slowing the rollback, or that something was hung.

Restarting means that it can roll forward/back without anyone else trying to read/write to the system, so...

You must have some open transaction in tempdb that is holding space. It should be in simple mode and truncate itself (log) every few minutes. If tempdb is growing constantly,...

We've talked about it and we hesitate to change the forum code too much. Makes upgrading hard.

I'll add this to the list and maybe there's a way that we can...

Forum moved and please try to post only what you think is relevant. We don't necessarily need to see the whole log.

I agree things move slowly and if you page out the Windows guy a few times at night, things might change. Or if you don't get a db working fast...

No differences between Truncate on checkpoint and simple I know of. The former is older syntax.

I agree with Michael, I'd run more frequent log backups and then add in another...

The only advantage for QA that I've seen is that it's quick and starts immediately. I don't need to spend time waiting on SSMS to start up, eat system resources,...

Look on the MS site for new things. Most things should be backwards compatible from the T-SQL side.