• Is the "no repair" answer correct?

    http://msdn.microsoft.com/en-us/library/aa258278%28SQL.80%29.aspx

    says:

    REPAIR_FAST Performs minor, nontime-consuming repair actions such as repairing extra keys in nonclustered indexes. These repairs can be done quickly and without risk of data loss.