Select Failures

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.

Related Posts

A Story Of Database Corruption

Jason Brimhall tells a tale of a corrupt database: Calmly, you settle in and check the server and eventually find your way to the error logs to see the following: Msg 823, Level 24, State 2, Line 1 The operating system returned error 1(Incorrect function.) to SQL Server during a read at offset 0x0000104c05e000 in file […]

Read More

CHECKDB For Read-Only Databases?

Erik Darling answers a reader’s question: So, can you run DBCC CHECKDB on a read only database? Should you run DBCC CHECKDB on a read only database? tl;dr: YES AND YES! Here’s why: Many forms of corruption that I’ve seen have come from storage. Sure, there have been bugs that were to blame, but yeah. […]

Read More


December 2015
« Nov Jan »