How to query table sizes of a DB in MSSQL 2005

Part of my job is to make sure that our database is optimized all the time. Sometimes you need to actually take a look of which tables in the database are causing the slow downs. This query will list all the tables of your DB as well as the number of records it has, size [...]