Track Database Disk-Space Usage on a Granular Level

One of the housekeeping challenges DBAs face is to keep track of their databases’ growth and how much space is being used by each table and index in those databases. To meet this challenge, I wrote a stored procedure, usp_ SpaceUsedAnalyzer, that extends the functionality of the sp_spaceused system stored procedure to present more detailed information.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=100213