SELECT Sum (part. rows ) row_count |
FROM Sys.tables Tbl |
INNER JOIN Sys.partitions Part ON Tbl.object_id = Part.object_id |
INNER JOIN Sys.indexes Idx ON Part.object_id = Idx.object_id |
AND Part.index_id = Idx.index_id |
WHERE Tbl. NAME = 'TableName' |
AND Idx.index_id < 2 |
GROUP BY Tbl.object_id |
,Tbl. NAME |