SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag size Rss

Search for any content tagged size

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 8 of 8   


Returns the size of the current SQL Server ERRORLOG file.  Read more...
Rating: |  Discuss |   Briefcase | 535 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2015/12/31 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,753 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,865 reads


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,408 reads

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,606 reads

Table Data Sizes

Script to display how the data is broken up between the tables.  Read more...
By Nick Greene 2010/12/08 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,947 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,686 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 7,203 reads
   Items 1 to 8 of 8