I remember seeing a query that returns the row count for a table using system
tables (i.e. NOT using COUNT(*)).

I have searched Books online, MSDN and a bunch of sites and cant find it.

Can someone please post that query please?