SQL Slammer used 1434 and it can be a problem. This port is used to discover other SQL Server instances and is a pain if it's not open, but you...

The DMV for plans shows what's in cached, but that doesn't tell you what's been run recently. If you had lots of different procs run, you might see them getting...

I don't know that there's a good collection anywhere that you can reference. Lots of blogs and short notes/articles around. Search "VLDB SQL Server".

You will probably have to consider filegroups...

Question has been changed to say 2005. Thanks for the comments.

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