Cheers Ian - it's a very useful little SP.

I am also finding it useful in detecting questionable queries - where the indexes for the tables have been planned out, but the sql server is raising issues of missing indexes, because the relevant query isn't written correctly to use indexes that are already in place.

A case of looking at the missing index hint and saying to yourself, "Why do you think you need that?"