Using system objects we can find tables inflammations like no of row, indexes, key columns, etc. sys.tables: Returns a row for each user table in SQL Server. sys.partitions: Contains a row for each partition of all the tables and most types of indexes in the database. sys.dm_db_partition_stats: Returns page and row-count information for every partition … Continue reading SQL Server Tables and row counts