Nothing to do with...

Koen already did.

Easiest way will be to add another column, call it DisplayOrder or something like that. Populate that column with the order you want the rows to be displayed and ORDER...

Post the exact command you're running and the exact error you're getting.

Simple, I make very, very sure that I'm not indispensable.

I make sure that others can do the majority of what I do, doesn't have to be as efficiently...

To be honest, there's no such thing as an active-passive or active-active cluster. There's a cluster and it can have 1 or more instances of SQL installed on it.

What tends...

Could you identify what command the app is running when it throws that error? Use a server-side trace if necessary.

And for some general info - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

The Dixie Flatline (6/14/2014)

GilaMonster (6/14/2014)

Yup, that's pretty much how I feel.

I have little interest in sport. Most of the time that's fine. This week, I...

...

To be honest, unless the description tends to be...

Yup, that's pretty much how I feel.

I have little interest in sport. Most of the time that's fine. This week, I can't even go to...

Repair is not recommended, do you have a clean backup?

You have a corrupt database, therefore you need to check hardware, IO subsystem specifically. The specific errors that checkDB throws aren't...

Probably because the joins weren't the limiting factor of the query's performance. Hard to say much more in general terms.

I hate soccer season.

Ideally, restore from a clean backup.