Did you ever get a real answer on this? I'm experiencing blocking issues on ReportServer database too (no it's NOT slow running queries - it is verifiable blocking). Id like...

Oh crap. Something got flushed and I don't think it was cache.

I know this is a very old thread but someone might find this useful. This is not a query but does let you see the installed features.

Run the...

Even better is to capture the wait_stats at two (or more) different times and query the delta. I have this script that gives me a quick 10 second snapshot of...

Rather than run  the job every 2 minutes why not use SQL Server Agent to run the job when it detects a blocked session?

1) Set server "blocked process...

I've seen the acronym RBAR (row by agonizing row) used to describe this. If the client that's doing the row-based processing is on a separate machine, you'll need to add...

I'd like the same and for exactly the same reason. Unless MS provides this necessary functionality, the only idea I can think of would be to fire a job and...

That's simply not true. An instance will not hang because you filled the tempdb database. Queries will fail and the instance will throw errors like 1105, but it most certainly...

I realize this is a very old thread but here is my .02 having managed numerous SharePoint databases. After all someone may still end up at this thread looking for...

Same problem here. Same exact faulting module, exception code, and offset. I checked the technet article referenced and it does not apply (we are not using linked servers to Oracle)....

Actually it would make a lot of sense.

Frankly t-sql scripting is better than either PL/SQL or whatever MySQL currently offers. I've administered all 3. The flow control in sqlplus or mysql is pretty lacking. All of my...

Better to just store the passwords in a password vault. 😉 By the time you crack it, the server will be decommissioned!

I tried to crack a password that I know...

According to the --help output, -m 131 is for sql 2000. For sql 2008 use -m 132