I think you're going to have to restore an older backup. That looks too damaged to be useful.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Typically I just let Windows balance them out via the normal scheduling. If you want to limit, rather don't use processor affinity (and please don't set maxdop to 1).

You...

http://sqlblog.com/blogs/paul_white/archive/2012/03/12/fun-with-aggregates.aspx

Welsh Corgi (3/3/2013)

---

GilaMonster (3/3/2013)

---

GilaMonster

Same way you check what any session is waiting for, sys.dm_exec_requests

If you believe that...

SQL Server Express does not support SQL Agent.

By installed, do you mean the service is there?

Check the permissions, the error is OS error 5, that is a permission problem.

Could be that in the detach the permissions on the files were changed, I have seen that....

Same way you check what any session is waiting for, sys.dm_exec_requests

If you believe that Kill with the statusOnly...

Drop the nolock. It has no effect on a table that is the target of an update, that's documented. It's also plain bad practice in most cases. Optimise the query,...

It does work, it's the correct and only way to get the rollback status and progress.

Check what the rolling back session is waiting for.

The SQL Server service does not have permissions on the log file or the directory it's in. Check the permissions, ensure that SQL Server service has full control over both...

You gave the command in your first post. KILL <spid> WITH StatusOnly

Just bear in mind that index_usage_stats only has info from the last time the database was started. If you have autoclose on or take the DB offline for any reason,...

Welsh Corgi (3/3/2013)

---

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure,...

Welsh Corgi (3/3/2013)

---

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing a...