Welcome to weblogs.com.pk Sign in | Join | Help

Knowing the counts of table entries in SQL Server

Here's the query to know the counts of the table entries in SQL Server

select object_name(object_id), row_count
from sys.dm_db_partition_stats
where index_id < 2
order by row_count desc

Published Thursday, February 28, 2013 1:54 PM by khurram
Filed under: ,

Comments

No Comments

New Comments to this post are disabled