Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag sp_spaceused Rss

Search for any content tagged sp_spaceused

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 4 of 4   

Quick table size information

Uses a loop and sp_spaceused to populate a temp table with size info  Read more...
By Gabe Tower 2016/07/04 | Source: | Category: table size
Rating: |  Discuss |   Briefcase | 719 reads

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: | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 1,935 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: | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 1,222 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 2008/09/04 | Source: | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 3,985 reads
   Items 1 to 4 of 4