Find Size of Each Table in Database#
If you need to find the size of each table in the database here is an easy way. EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'" I use it to find those pesky tables that are hogging all my disk space. (Usually it's the log file though) Source: http://www.4guysfromrolla.com/webtech/032906-1.shtml
Thursday, September 11, 2008 2:45:13 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

All content © 2009, prag
On this page
Find Size of Each Table in Database
This site
Syndicate
Calendar
<January 2009>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567
Archives
 Full Archives By Category
December, 2008 (2)
November, 2008 (5)
October, 2008 (2)
September, 2008 (2)
July, 2008 (3)
June, 2008 (2)
March, 2008 (2)
February, 2008 (1)
January, 2008 (3)
December, 2007 (2)
November, 2007 (2)
October, 2007 (8)
September, 2007 (2)
July, 2007 (1)
May, 2007 (1)
January, 2007 (1)
December, 2006 (1)
November, 2006 (12)
October, 2006 (8)
September, 2006 (15)
August, 2006 (3)
July, 2006 (3)
June, 2006 (17)
May, 2006 (9)
April, 2006 (1)
March, 2006 (6)
February, 2006 (6)
January, 2006 (3)
December, 2005 (6)
November, 2005 (1)
October, 2005 (2)
September, 2005 (6)
August, 2005 (7)
July, 2005 (5)
June, 2005 (8)
May, 2005 (11)
April, 2005 (14)
March, 2005 (7)
Sitemap
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Blogroll OPML
 Healthy Reader
 Pop Therapy
 Slippery Brick
 The Art of Ware
 Wealthy Reader
 What's your 20
Disclaimer

Powered by: newtelligence dasBlog 1.9.6264.0

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts