Someone who is just dbo can't make changes to the sa account. Someone who's sysadmin (and dbo as a result of being sysadmin) can.

Are you running a 32-bit instance by any chance?

But for getting the expensive queries you won't be using sys.dm_exec_requests (that shows currently running queries), so CPU not being displayed correctly in that one doesn't matter for your problem.

AFAIK, the DMVs show correct data.

Well you should be running CheckDB on a regular basis anyway...

As for whether the DBs are fine or not, depends on exactly what the drives went through, so rather be...

Sorry, I don't understand your question

It's not log shipping you need the memory for, it's when your primary fails and you have to switch over to the secondary to keep the app running. The question...

Actual rows 0, so not 100% sure, but I suspect what's happening is that the TOP only ends up requesting one row from the stream aggregate. Stream aggregate isn't a...

Open the XML in a text editor, do a find/replace for table and column names. Save, make sure it still loads in SSMS, if so post it.

Couple other things.

Don't use the Profiler GUI against a production server. It can and will cause problems, up to and including crashing the server (I've done it). Statistics profile is...

Please post the execution plan. A picture doesn't have all the properties needed.

It's worth noting that a scan doesn't have to be the entire table, and that's probably what's happening...

NM, didn't read

Start with this: http://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/

Updating data, if not in an explicit transaction, will be in what's called autocommit mode. An implicit transaction started as the statement starts and automatically committed when the update finishes.

It's possible to recreate the DB from the files.

It's not a restore though, you don't have a backup. You can attach the files as a new database, providing they are...