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

Find no of records in each table in database (against Clustered Index)

If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.  Read more...
Rating: |  Discuss |   Briefcase | 1,362 reads

Count all records the tables

Count all the records from the tables that exist in a database  Read more...
Rating: |  Discuss |   Briefcase | 1,843 reads

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,806 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,609 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 | 51,659 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 | 51,659 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (2)    
space used (1)    
table row count (1)    
table size (1)