Use the following query to get the total number of rows for each table in your database:
CREATE TABLE #TempTable
(
[Table Name] [varchar](max),
[Total Records] int
);
EXEC sp_MSForEachTable @command1 = ' Insert Into #Tab(Table_Name, Total_Records) SELECT ''?'', COUNT(*) FROM ?'
SELECT * FROM #TempTable t ORDER BY t.[Total Records] DESC;
DROP TABLE #TempTable;