• 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!