I'd start here: http://www.sqlservercentral.com/Articles/Access

Then there are some Access books I've seen that cover this. I don't have any off the top of my head, but I'd look through a few...

It can't be 28MB of memory. I doubt SQL Server runs in 28MB.

You must have something else going on with the box. I'd re-open the case and work through it...

I'd avoid surgery if at all possible. Used to work for an ortho, and they make lots of little mistakes at times, nothing major, but it might cause you issues...

You can read about it here as well

http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

Tend to agree with Alex, but you have to examine where each query is slow. What might be making it slow. Look through query plans, etc.

Personally I think it might be hard. Most likely we'll have some junior or intermediate DBAs nominating seniors at larger companies.

At the majority of my jobs, meaning 5 or 6...

I think you'd implement this as T-SQL logic, a stored proc perhaps, and then call that from SQLCMD.

don't forget to check for pathing issues. I'd get the virtual names and then set the new paths in my restore server for every file using some standard in the...

Securables are objects. It's not clear what you mean by "permissions (securables)"

It sounds like your other DBA gave permissions to execute all stored procedures. That doesn't have anything to do...

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.