Select * from sys.databases shows my database is in 'Recovering' state_desc. The error log shows that it will take 6 days to recover. Is there anything I can do to...

MyDB is now "In Recovery" after stopping / restarting sql service.

2012-06-14 10:59:15.56 spid35s Recovery of database 'WebData' (6) is 0% complete (approximately 519461 seconds remain). Phase...

kill 88 with STATUSONLY

Results in...

SPID 88: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

How can i check on the progress? SPID 88

Well it looks like SPID 88 was a hung job that was doing a bulk insert. The job was stuck running for the past few days. I stopped the job...

That's a nice query! Thanks!

Well it looks like there is no LOG directory and no .trc files anywhere. Why would the vendor set it up this way?

Before restarting the server and having tempdb recreated,...

Outstanding! Thank you!

I FINALLY GOT IT! It turns out that the original query you gave me was ordering by MD Name and not Days Since.

So here is the final query! Thank you...

dwain.c (4/23/2012)

---

Can't mess with your original query without lots of DDL, but I can show you how to take it from where you are now to where you want to...

That looks great! Thanks Dwain I will give it a shot. I am really new to TSQL but should pick this up quick.

Can you provide an example. All my attempts were last week and I did not save them. I just kept getting such and such field is not included in aggregate...

Yep, I noticed that Prod and Test only had 6 views and when opening each view they all matched # rows returned and then i ran queries on the tables...

Restore 10,20,...100% complete

The test db size then matched the production db. So I'm at a loss to their claim that the prod data isn't in test after the restore. I...

I had a chance to speak with our vendor in regards to the server memory issues. I was forwarded an email that pertains to the following application error:

"Viewer Err: Display_feed.asp:...