I've been handed a database 90% of the size is in one table. This really bothers me because there are only 700 records in it!
It averages 25k per row, looking though the table most of the fields are blank. I found a field "Supervisor" that I could normalize, but it made no noticeable difference.
Exporting the table as a CSV file gives me a 230k file!
Deleting the table knocks down a 19.3 Meg file to a 1.8 Meg file.
Any ideas?