<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
sp_spaceused
Items 1 to 3 of 3
The joy of sp_spaceused
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
Read more...
By
Benson Sibanda
2012/06/22
|
Source:
SQLServerCentral.com
|
Category:
sp_spaceused
Rating:
|
Discuss
|
Briefcase
|
1,802 reads
Space Used By Table
Small script I use to find tables that are running away with the space.
Read more...
By
Eric Wahner
2009/03/04
|
Source:
SQLServerCentral.com
|
Category:
sp_spaceused
Rating:
|
Discuss
|
Briefcase
|
1,168 reads
Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
Read more...
By
Gaby Abed
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
sp_spaceused
Rating:
|
Discuss
|
Briefcase
|
3,800 reads
Items 1 to 3 of 3
Tags
database size
(1)
growth
(1)
monitoring
(1)
space
(1)
sql server 2005
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
