SQL SERVER - How to Find Row Count of Every Table in Database Efficiently? - SQL Authority with Pinal Dave[
^]
All you need to do is filter that query to only return the details for the tables you want:
SELECT
SCHEMA_NAME(T.schema_id) As SchemaName,
T.name As TableName,
SUM(P.rows) As TotalRowCount
FROM
sys.tables As T
INNER JOIN sys.partitions As P
ON P.object_id = T.object_id
And P.index_id In (0, 1)
WHERE
Exists
(
SELECT 1
FROM dbo.Archive_Config As A
WHERE A.TableName = T.Name
)
GROUP BY
SCHEMA_NAME(T.schema_id),
T.name
;