Hi,

Reading through the indexes is a smart move! I might steal the idea 🙂

If I may have some improvement suggestions:

1. Instead of index(1), use select * simply, orelse LOB pages are not checked.

2. I'd prefer checking the system tables as well.

3. Watch out for filtered indexes - orelse QP will kill the script, not the IO error 🙂

4. I'd pick a different title. As Paul highlighted, DBCC CHECKDB has no real alternative. So the title is catchy but probably a "Detect Disk Corruptions Superfast" or similar would manage expectations better.

Cheers,

Erik