Total Database Information At Your Fingertips Part

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rahul Kr. Ghosh » Total Database Information At Your Fingertips...

Total Database Information At Your Fingertips Part - II

Rate Topic

Display Mode

Topic Options

Author

Message

Rahul The Dba

Posted Wednesday, November 23, 2011 9:57 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:32 AM
Points: 127, Visits: 122

Comments posted to this topic are about the item Total Database Information At Your Fingertips Part - II

Rahul Tongue

Post #1211434

Hardy21

Posted Wednesday, November 23, 2011 9:57 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158

Thanks for sharing.

Thanks

Post #1211435

jtrueman

Posted Thursday, November 24, 2011 2:17 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:13 AM
Points: 62, Visits: 48

There is faster way how to determine total number of rows in table, then in all tables as well. If you have primary key on your table (so it doesn't works that simply for heap tables) you can just simply select rowcnt column on sysindexes where id = objectid('yourtable') and indid = 1.

This gives you number of rows in your primary key, which is the number of rows in your table. Subsequently if all tables in your database has a PK, just simply sum all rowcnt columns in sysindexes table.

Jan

Post #1211497