;With XMLNAMESPACES(DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
,s as (SELECT query_hash, query_plan
FROM sys.dm_exec_query_stats AS qs 
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle)
)
,[tables] as (
Select query_hash
,t.n.value('@Database', 'sysname') [database]
,t.n.value('@Schema', 'sysname') [schema]
,t.n.value('@Table', 'sysname') [table]
from s
Cross apply query_plan.nodes ('//Object') t(n)
)
Select Count(distinct query_hash), [database], [schema], [table]
from [tables] a
Where a.[database] is not null
Group by [database],[schema],[table]
Order by 1 Desc

private static string GetXmlPlanForQuery(string queryText)
{
    string result = null;
    using (var connection = new SqlConnection(connectionString))
    using (var command = new SqlCommand())
    {
        connection.Open();
        command.Connection = connection;

        //Enable the statistics.
        command.CommandText = "SET STATISTICS XML ON";
        command.ExecuteNonQuery();

        //Run through the query, keeping the first row first column of the last result set.
        command.CommandText = queryText;
        using (var reader = command.ExecuteReader())
        {
            object lastValue = null;
            do
            {
                if (reader.Read())
                {
                    lastValue = reader.GetValue(0);
                }
            } while (reader.NextResult());

            if (lastValue != null)
            {
                result = lastValue as string;
            }
        }
    }
    return result;
}

FROM sys.dm_exec_query_stats AS qs 
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle)

FROM таблица_с_текстами_запросов AS qs 
CROSS APPLY GetXmlPlanForQuery(qs.текст_запроса_из_таблицы)