You can change the password without knowing the old one, as long as you are a sysadmin (or a security admin and account you're trying to change is not sysadmin)

SQL...

Won't help here. As I said, it's not about the size of the...

Interesting, not quite what I was expecting.

That's a table that stores info on what columns exist in what objects. Latches protect the physical structure of the page, so that two...

Swirl80 (5/20/2010)

---

Funnily...

Could you run this and post the results? It's an undocumented command to look at a database page's raw structure (in this case, just the header)

DBCC TRACEON(3604)

DBCC PAGE (5,1,11099981)

DBCC TRACEOFF(3604)

It's better to do neither.

Have you identified why the log is growing? Full recovery and no log backups?

See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Why do you want to shrink at all?

That's not what I asked for. Need the wait_type and wait_resources please for processes that are waiting (ie suspended).

How many CPUs on this system? Is there only 1 file in...

Could you do some checks and see what the page latch waits are commonly on? The wait_resource in sys.dm_exec_requests. I have a suspicion that I want to verify.

How many files/filegroups...

Would you mind posting the definition of the table aliased as pe?

Yeah true. That as well.

No priority options exist. Either wait as it is now, or restart. I suspect something external from SQL's holding it up. Might be worth recycling MSDTC, see if that frees...

Swirl80 (5/20/2010)

---

Interesting, i knew about parameter sniffing in terms of a parameter being passed to a procedure but not being able to work out its value, but not when its...

1204 is not the best traceflag to use on SQL 2005 or higher.

Switch traceflag 1222 on. That will result in a more detailed deadlock graph been written to the error...