Árvore de páginas

No banco que se deseja verificar o número de registros, executar:


SELECT OBJECT_SCHEMA_NAME(object_id), OBJECT_NAME(object_id) AS ObjectName, partition_number, rows
FROM sys.partitions
WHERE OBJECTPROPERTYEX(object_id, 'IsMSShipped') = 0
 AND index_id IN (0, 1)
ORDER BY rows DESC;