33.How to show table row count and Data space used in SQL Server with SSMS
There's a quick and convenient way to see row count, data space used in all tables in one list with SSMS.
Query to find table row count :
SELECT SCHEMA_NAME(t.schema_id) SchemaName,
t.[name] TableName,
SUM(p.row_count) TotalRows
FROM sys.tables t
INNER JOIN sys.dm_db_partition_stats p
ON t.object_id = p.object_id
AND t.type_desc = 'USER_TABLE'
AND p.index_id IN (0,1)
WHERE t.[name] = 'SalesOrderDetail'
GROUP BY t.schema_id, t.[name]
ORDER BY TotalRows DESC
On this page of the site you can watch the video online 33.How to show table row count and Data space used in SQL Server with SSMS with a duration of hours minute second in good quality, which was uploaded by the user Vasanth R 28 March 2022, share the link with friends and acquaintances, this video has already been watched 90 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
