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...

Still stumped. I ran the query provided, and it only shows 800MB free in the data file:

UsedSpaceMBUnusedSpaceMBType

26.969446.66Log

23448.25800.00Data

23475.2110246.66*** Total for all files ***

I get the extra space in the log file,...