Find total records in various tables in a single query

Question

Currently I m using this query ,Is there any substitution for this query,which will work more faster .

SELECT 
    SUM(result1),
    SUM(result2),
    SUM(result3)
FROM (
    (
        SELECT 
            0 as result1,0 as result2,COUNT(*) as result3
        FROM 
            table1
    )
    UNION
    (
        SELECT 
            count(*) as result1,0 as result2,0 as result3
        FROM 
         table2
    )
    UNION
    (
        SELECT 
            0 as result1,count(*) as result2,0 as result3
        FROM 
            table3
    )
    ) as allresult

Answer 1

Alternate solution of above query is as below:

SELECT (SELECT COUNT(1) FROM table2) AS result1, 
       (SELECT COUNT(1) FROM table3) AS result2, 
       (SELECT COUNT(1) FROM table1) AS result3;

Answer 2

Add the table names in the WHERE clause and execute the below query:

SELECT 
    T.Name AS TableName,
    S.Row_count AS RecordsCount
FROM 
    sys.dm_db_partition_stats S
INNER JOIN sys.tables T ON T.object_id = S.object_id
Where 
    Object_Name(S.Object_Id) IN ('Employees','Country')