We had one of our biggest databases (>100 Tb) being suspect. Analysing the logs said it was caused by to some failing disk operation during a checkpoint. Which is kind...

If you do not know the composition of the (clustered) indexes of the huge table, how can you suggest any significant performance improvement? It will do a full table scan...