Multiple Table reads

I know this doesn't directly answer your question, but if you want to find every procedure that references a table more than once, this will work.

In SQL Server 2000, the syscomments system table contains the text for all stored procedures. For SQL Server 2005 and 2008, this has been replaced by sys.sql_modules. The biggest difference is that syscomments contains multiple rows for the same procedure if it is over 4000 characters. This is not necessary with sys.sql_modules because it uses the nvarchar(max) data type.

Please note: The following script will search the procedure text for whatever you specify for @TableName. If the name is something like "SpecialCustomerTable", you will probably get good results. However, it could return too matches if your table name is a common word used in comments or other places.

DECLARE @TableName varchar(200)
SET @TableName = ''

-- procedures which contain the same word or phrase twice in less than 4000 characters
SELECT o.name
FROM syscomments sc
    INNER JOIN sys.objects o
    ON sc.id = o.object_id
WHERE o.type = 'P'
    AND sc.text LIKE '%' + @TableName + '%' + @TableName + '%'
UNION
-- procedures which contain the same word or phrase twice in over than 4000 characters
SELECT o.name
FROM syscomments sc
    INNER JOIN sys.objects o
    ON sc.id = o.object_id
WHERE o.type = 'P'
    AND sc.text LIKE '%' + @TableName + '%'
GROUP BY o.name
HAVING COUNT(*) > 1
ORDER BY o.name

It's kind of hard to define "double work" because a given query might legitimately hit a table multiple times. However, one approach you could use is to query the plan cache using XQuery. You could look for plans that reference a table more than once. That's only going to capture the stuff in cache. Depending on your system and how fast it's flushing the cache, you might need to run the query more than once a day.