If the clustered index name is null, then that's a heap, a table without a clustered index.

Paul Randal is doing a couple of corruption courses for Pluralsight.

Something has written zeros over a largish portion of your database file. That's not 'OK'. Doesn't have to be the disks, anything in the IO subsystem.

Yes, you've got some problems with your IO subsystem that's caused major, widespread corruption in your database.

Restore from a clean backup (one taken before the corruption occurred).

They have the type 'S' in sys.objects?

I'm done with MS certs. From what's been said (which I cannot repeat), I'm not at all optimistic about their plans.

Neither of those will be achieved by shrinking the file.

A file won't...

No, you cannot create indexes on system tables. Are the CDC tables system tables though?

If you want to pay them, sure.

Doesn't when I test. It does however throw

Msg 16924, Level 16, State 1, Line 69

Cursorfetch: The number of variables declared in the INTO list must match that of selected...

Running CheckDB on a restored backup is fine. However, monthly is maybe not fine. Do you retain all your backups for a full month? If not, what are you going...

MyDoggieJessie (9/9/2013)

---

If your last checkdb fixed the data consistency errors and you took a full backup afterwards, that backup would be good (albeit, you may be missing some data). ...

And the error reads..... ?