I have a SQL Server database with multiple hundreds of data tables in it, and I am looking for disk usage statistics, as it relates to each individual table.
Is there a quick way to find this information?
Marc Brown put together a stored procedure using the sp_spaceused and sp_tables system stored procedures to gather that information. Also, if you don't mind using a Microsoft private procedure, this stored procedure is a bit shorter method of accomplishing the same goal.
Which SQL Server version?
For size you look into
For IO you look into
Another possible approach is to enable performance collector sets and use the SQL Server 2008 Management Data Warehouse.