A friend working at Graphico of my recently sent me some SQL that purposed to look for missing indexes in you databases.  It pretty much sat in my inbox for a while until I had time to look at it (which I have just done).

It was a great little script and proved very useful in identifying performance improving indexes that we could include in the database that we're developing.  I asked my friend where the SQL was from and he pointed me to the article in question on the MSDN site, which you can find here:

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

It really is worth a read and has some very interesting stuff in it.  Cheers for that, Paul - most useful!