A quick script using sys.dm_db_partition_stats that lists the row count of every table and shows the largest table in database right at the top.
A quick script using sys.dm_db_partition_stats that lists the row count of every table and shows the largest table in database right at the top.