10.50.1617.0

No, there aren't. I'll patch this server when I get the chance.

SQL Server 2008 (10.0.1600.22)

Windows Server 2008

This is the central server.

No policy-based management.

No, sorry, should've mentioned that. I've seen that thread before, tried everything, same boat.

yeah, this is my last resort. i've read a couple of articles that say that when a dbcc operation is canceled it can sometimes get to a point where...

Yes, it is still in killed/rollback. It's been like this for 7 days now, and it only ran for 6 hours to start with. From what I can...

Nothing helpful. Estimated rollback completion 0%. Estimated time remaining 0 seconds.

Thanks...sorry, I just eyeballed the script.

Thank you Gail.

Damn. In my actual sproc, I am using >= and <=, not between's. I just used between in this test example because I figured it didn't make a...

Plan attached

so the query would have to betweens, one that encapsulates my parameters and one that defines the boundaries..? Hmm..no, haven't tried that. Seems like it would be a...

Haven't posted an exec plan to SSC before. What format is preferred?

Again, not it doesn't. 🙁

The select statement in the actual query is complex, however, the same exact results (SQL not using the index in the execution plan) can be achieved by the following:

declare @begin...