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

Content with tag Row Count Rss

   Items 1 to 5 of 5   
 

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

List table space usage and row counts

One query to list space used and row counts of all tables  Read more...
By Louis Li 2014/01/17 | Source: SQLServerCentral.com | Category: row count
Rating: |  Discuss |   Briefcase | 1,403 reads

How To Get Table Row Counts Quickly And Painlessly

Use sysindexes\DMVs insead of select count(*) to retreive table row counts  Read more...
By Kendal Van Dyke 2011/01/28 (first published: 2009/09/02) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 50,708 reads

How To Get Table Row Counts Quickly And Painlessly

Use sysindexes\DMVs insead of select count(*) to retreive table row counts  Read more...
By Kendal Van Dyke 2011/01/28 (first published: 2009/09/02) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 50,708 reads
   Items 1 to 5 of 5   
 
Tags
space used (1)    
table row count (1)    
table size (1)    
t-sql (1)