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
Scripts with tag
sp_spaceused
Search for
any
content tagged
sp_spaceused
Add a script
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,792 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,167 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/05/25
|
Source:
SQLServerCentral.com
|
Category:
sp_spaceused
Rating:
|
Discuss
|
Briefcase
|
3,777 reads
Items 1 to 3 of 3
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.