I needed a report to give me table growth by day for all of the tables in a given database.
I decided to start my table stats gathering by using the "sp_spaceused" stored procedure which gives data,index and unused space allocation for a given table. I combined this procedure with the undocumented sp_MSforEachTable statement to give me each owner.table combo in the database. I've used the below code as a base for my reporting. It's been added on for my needs but you can use the base for anything you like. Have fun.
The code below creates the temp table to hold all of the data for each table in my database.
I order it by the object total space used in descending order.