I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation of table and index sizes:
It can be very handy when you need to quickly understand what are the main tables in a database.
It can also help you spot situations where the indexes of a table take a great amount space, perhaps more than they should.
I think the main use cases for this tool are when you see a new system and want a quick jump start, whether you are a consultant, start in a new work place or handed a new system.
Take into account it can take some time for the tool to run if you have a-lot of tables and indexes in the database.