Specialization tends to happen over time, and it's not just technology; it could be industry or type of company. It's probably more common for development areas than administrators.

I haven't really...

There's also a wizard in EM that creates a DTS package for you. Use the Import Wizard against the target server.

All user databases should pick them all up. It's possible that "all" is resolved at design time and picks up specific databases, but I would have thought that was fixed...

As Matt mentioned, there is lots to look at. The specific query will matter, but indexing is probably more important. Check for indexes on the title or other relevant fields.

Also,...

Is this a remote or local connection? You might need to set the user and password or perhaps the trusted connection switch in your command or in your file.

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

How are...

A Christopher has mentioned, wrap your query inside another as a sub-select and return only the PKs needed to the outer query.

You can nominate someone at http://www.exceptionaldba.com/

Nigel was not renewed in April 2008 as his work commitments prevented him from contributing substantially to the community in 2007. However he is well...

Haven't seen that. The task should call some sys.databases, so if the account can see the databases in that view, they should come through.

Not sure why you wouldn't see them....

Can't do it. Need to take the db offline to move the log file.

Does your machine authenticate with a domain when you VPN in?

I agree with Matt as well, and also ask that if someone hasn't made any attempt to solve something or figure it out, ask them to. We don't want to...

you need to do some math to get the results.

You can divide by 1000 to get seconds, then you'd have to divide by 60 to get minutes, and subtract...

You have good points on efficiency, and those items do matter when you compare cars. That's one good thing about the Xprize. They "charge" for electricity so that there's a...

Use SSIS, there's a data import wizard in SSMS that will help you.

This seems like homework, please ask the OP to make an attempt before you give the answer here.