It often happens that you need to know how big a table is. There are many reasons for this: finding which tables have the most rows; understanding which tables tend to grow the fastest; find which table is using the most space.
I found a nice query on stackexchange.com that listed the tables, row counts and data sizes in a database: