SQL SERVER - Select para retornar todas as tabelas e a quantidade de registros - Select to return all the tables and the number of records

Essa Select retorna todas as tabelas e a quantidade de registros de cada tabela do SQL Server.

SELECT T.NAME TABELA, P.ROWS QTDE
FROM SYS.TABLES T
INNER JOIN SYS.INDEXES I
ON I.OBJECT_ID = T.OBJECT_ID AND I.TYPE IN (0,1)
INNER JOIN SYS.PARTITIONS P
ON P.OBJECT_ID = T.OBJECT_ID AND P.INDEX_ID = I.INDEX_ID
ORDER BY T.NAME ';