How can I get the size of tables inside the DB

[Pack10]

I have a database that I use for all my ad-hoc queries.
The table has grown to be quite large and its gotten very slow. I want to do a cleaup. Is there a way to tell the size of the records in the tables. I would like to loop thru all the tables and see their size.

thx

 

[Golom]

Have you compacted the database recently (or ever)? That's usually the first step in trying to improve performance.

Performance issues are not solely dependent on the physical size of the tables. Issues like indexing and the nature of the queries that you are running are often more critical to good performance than just record counts or bytes in the table.