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

Content with tag space Rss

   Items 1 to 6 of 6   
 

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.  Read more...
By Gonzalo Moles 2013/09/13 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 2,372 reads

Space used by db files

Often I've been requested to move a db from one server to another. This script is based on another script I found on the Internet, I cannot remember the name of the Author or track down which site it was.  Read more...
By Ronan Govender 2013/06/12 | Source: SQLServerCentral.com | Category: space
Rating: |  Discuss |   Briefcase | 987 reads

sp_spaceused2

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,370 reads

Disk space alert per drive

This script validates the sufficient disk space per drive. When you'll reach a minimum on a diskdrive, the script will mail all recipients.  Read more...
By Sven Goossens 2011/12/06 | Source: SQLServerCentral.com | Category: storage management
Rating: |  Discuss |   Briefcase | 3,093 reads

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.   Read more...
By sql frenzy 2009/07/02 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,597 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
   Items 1 to 6 of 6   
 
Tags
size (2)    
alerts (1)    
calculate (1)    
clustering (1)    
data files (1)    
disk (1)    
drive (1)    
estimate (1)    
heap (1)    
mail (1)    
maintenance (1)    
monitoring (1)    
non-clustered (1)    
sp_spaceused (1)    
storage management (1)    
table (1)    
used (1)    
warning (1)