Home : Products : General : Determine table sizes and disk usage for a database in Microsoft SQL Server
Q10453 - HOWTO: Determine table sizes and disk usage for a database in Microsoft SQL Server
  1. Download the attached script
  2. Open Enterprise Manager / DBA Studio
  3. Login to the database that you are trying to analyze
  4. Open a new query window
  5. Open Script in Notepad
  6. Select all text and Copy it.
  7. Paste the text into your query Window
  8. Click EXECUTE
  9. You should get a result back looking like this :

See Also: Recommendations for Index Maintenance in Microsoft SQL Server

Related Articles
No Related Articles Available.

Article Attachments
datafile_table_size_analysis.txt

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
works with Microsoft SQL 2008. Very helpful Approved: 3/9/2010 8:43 AM
very useful script that works on both 2000 and 2005 SQLs. thanks! Approved: 6/12/2008 9:42 AM
Created on 9/14/2007 2:28 PM.
Last Modified on 3/29/2016 11:54 AM.
Last Modified by Scott Dorner.
Skill Level: Novice.
Article has been viewed 10270 times.
Rated 8 out of 10 based on 9 votes.
Print Article
Email Article