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

Scripts with tag Table Size Rss

Search for any content tagged table 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 3 of 3   
 

Calculate Table Size and row count

This script calculates table row count and size(MB), as well as the used space and free space.  Read more...
Rating: |  Discuss |   Briefcase | 1,699 reads

Easily calculate the size of your tables

This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)  Read more...
By Sylvia Moestl Vasilik 2009/05/04 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 1,579 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.  Read more...
By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 2,967 reads
   Items 1 to 3 of 3