Paul Randal walks us through a complicated scenario involving corruption:
An interesting corruption problem cropped up on the MCM distribution list yesterday and after I figured it out, I thought it would make a good blog post in case anyone hits a similar problem.
In a nutshell, the problem was corruption such that a simple SELECT * query failed, but a SELECT * query with an ORDER BY clause worked.
This is interesting, but hopefully you don’t encounter these types of problems very often in your environment.