如何使用磁盘空间使用情况检索数据库中所有表的结果集

Is there a T-SQL query I can run against a database that will provide a list of all tables in that database as well as their current disk space usage? I know I can look at it in SSMS with the "properties" dialog, and I know how to use the sp_spaceused sproc to see it one table at a time but I'd like to evaluate the disk space usage of all of my tables, ordered by highest disk space usage to lowest. We need to cut our DB size down significantly so I'd like to see which tables are the worst offenders.Is there a T-SQL query I can run against a data