Yes, and it wouldn't compile.

Thanks, tried recompile to no avail. Dynamic SQL it is!

Yes, yes, shame on me about the backup schedule. Let's please withhold judgment for now, ok?

State of DB (OHM) is "RECOVERY_PENDING"

Log -

09/29/2011 23:03:57,spid51,Unknown,During undoing of a logged operation in...

Thanks

Yes, we have the field indexed. Thanks, though. 🙂

also, all subscriptions have been removed.

Yes, yes, understood, the hardware configuration is not great. As previously mentioned, when I made the hardware request, we were still very much in the proof of concept phase....

It's not a 3 disk mirror. It's 3 mirrored volume across which the db partitions are spread. Plenty of reports out there that indicate that this is faster...

BCP is certainly something to think about. Yeah, I agree that we need faster HDD's. We've got a Dell MD1220 attached storage with 24 1TB drives spread out...

It is a SELECT only, with multiple joins on PK-FK relationships to child tables. There is no inserting, updating, or deleting.

As far as the number of concurrent processes hitting...

haha..yeah, i've gotten sucked into that one a few times.

the thread that will never end. i changed it back quickly *AFTER* it finished. 🙂

yeah...i changed it on one particular query just to see if it made any difference. quickly changed it back. my cxpacket wait times weren't anything crazy anyhow. ...

Thanks. I've used a very similar query and no luck. The only blocking that's occurring is coming from CXPACKET wait types. I've turned down MAXDOP and it...

After my linear guesstimates didn't work out, that's what I tried doing instead, really hoping to look like a genius. You're right, no so fun when they weren't thrilled...