I could have bet on anything that SQL Server has atomic disk writes so no crash can possibly corrupt anything, well, after a power outage I had a database marked as (Suspect) by the recovery. The only way to actually get it back running was DBCC with REPAIR_ALLOW_DATA_LOSS that indeed has lost an entire table full of data along with some other fields around.