Based on this post, and with some independent research, I have written a brief article here - http://beyondrelational.com/blogs/nakul/archive/2011/04/04/measuring-the-number-of-rows-in-a-table-are-there-any-alternatives-to-count.aspx
The article attempts to compare the known alternatives of COUNT(*) in terms of performance (time) and accuracy.
Hope you like it.
Thanks & Regards,
Be Courteous. Drive responsibly.
commented on Mar 12 2011 2:47PM