Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sp_spaceused Rss

   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,898 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,200 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: SQLServerCentral.com | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 3,919 reads
   Items 1 to 3 of 3   
 
Tags
database size (1)    
growth (1)    
monitoring (1)    
space (1)    
sql server 2005 (1)