• Why not just compare @@RowCount against (select count(*) from TABLE)?

    When I query sys.dm_db_partition for some of my tables I have multiple rows returned whose row_count is either <= count(*).

    If I SUM these as the example shows the result is multiples of count(*).

    And Everytime @@RowCount = count(*).