Rowcount for All Tables

Posted by Derek Dieter
on June 17 2009

Sysindexes stores the table rowcounts based on statistical updates. While this query is not the most accurate, because statistical updates can be out of sync, it is definitely the quickest and least intrusive.

SELECT SUM(rowcnt)
FROM sysindexes
WHERE indid &lt; 2

Related Posts:
»Reindex All Tables in a Database
»Find Missing Table and Index Statistics
»SELECT TOP 1
»Auto Update Statistics & Auto Create Statistics
»List All Tables in a Database
»The Merge Statement
»Best SQL Server Pagination Method
»Index Usage DMV
»SQL Server Interview Questions
»Alter Index All Tables

Popular search terms:

Filed under Scripts Tagged rowcount

Comment (RSS) | Permalink

post a comment OR Post Your Question on our ASK! Community!

Random MVP RSS Feeds
- [SQLTeam] How to import in BIDS more than one SSIS package in one shot!: Have you ever wanted to add more than o... http://t.co/ZfC9u8I1 about 9 hours ago from twitterfeed
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 01:33:19 AM January 31, 2012 from SQL Server Planet
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 07:58:09 PM January 29, 2012 from SQL Server Planet
- DROP INDEX SYNTAX - Here is the syntax needed in o... http://t.co/ElqNyG3e #fb 07:05:16 PM January 29, 2012 from SQL Server Planet
- SET TRANSACTION ISOLATION LEVEL - This statement is used to set... http://t.co/0zGtNE1X #fb 06:10:38 PM January 29, 2012 from SQL Server Planet
- [Aaron Bertrand] Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR: I see a lot of people suggest while ... http://t.co/oDLn0pVs 10:12:20 PM January 26, 2012 from twitterfeed
- [Simon Sabin] Ten reasons to attend SQLBits X: If you are contemplating attending then I hope the following will... http://t.co/Zg6uqojD 12:54:21 PM January 26, 2012 from twitterfeed
- [Simon Sabin] SQLBits x an awesome line up –1100 people have already registered: I was really happy to have put ... http://t.co/zQu3m5ix 07:48:47 PM January 25, 2012 from twitterfeed
- [Aaron Bertrand] SQL Server 2012 : The "Launch Date" is not what you think it is: I see a lot of people getting ... http://t.co/i87shAFB 02:18:00 AM January 24, 2012 from twitterfeed
- [Aaron Bertrand] Bad Habits to Kick : Using AS instead of = for column aliases: This one is quite subjective, an... http://t.co/5uzyQWCv 05:49:21 PM January 23, 2012 from twitterfeed