mssqlfun.com
DMV-14 : Which Table has Max. rows & Size……..sys.dm_db_partition_stats
sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: Returns page and row-count information for every partition in the current database. This DMV gives useful infor…