Blog

SELECT sch.name +'.'+ tab.name AS TableName , SUM(pa.rows) AS TableRows FROM sys.tables tab INNER JOIN sys.partitions pa ON pa.OBJECT_ID = tab.OBJECT_ID INNER JOIN sys.schemas sch ON tab.schema_id = sch.schema_id WHERE tab.is_ms_shipped = 0 AND pa.index_id IN (1,0) GROUP BY sch.name,tab.name ORDER BY sch.name +'.'+ tab.name