mgrubbs 50094 (11/2/2012)
It looks like 6 of the tables are heaps. Is it just ALTER TABLE <TABLENAME> REBUILD?Is there any risk to doing that?
Also, there are no varchar(max), but a few with 150 or 250. Would a reorg with LOB_COMPACTION help here?
Thanks for all the feedback!
I changed my last post to say you should run DBCC CHECKDB first, and added the format for the table rebuild.