All answers have been marked correct.

Having both looked for lots of jobs and gotten a dozen, and hired people before, I'll say that the ad usually asks for more than we'd accept. Often every possibility...

We gave away the free admission to someone local. It's a promotion, not really a money maker, so we didn't want to sell it here.

Too often I see companies still...

If you're trying to check for success, then you can execute the batch as

sp_adduser 'aaa' ; select @@error 'error'

and that would return the error level. 0 would indicate no error.

In the example above, if there was an error, a one row, one column result set would be returned. The column would be named "returnval" and would have a 1....

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...