I was stupid and could have saved myself a lof of typing. Your query looks at the index usage and according to that decide what is unused. The other query looks at all the indexes and get those that has no stats on. Now, my question is: Is both queries good or if one is good which one is it. To everyone that reads this, please I am calling all boffins to please tell me.

Before you now fly off to answer this I first have some confessions to make because I have sinned. When I took responsibility of this database, now remember I am a developer and have never had the necessity to DBA a database, I had learn, and learn very fast. Someone told me about DTA (database tuning advisor) and I ran it and I applied all of it's recommendations. Now my database is bloated and I need to get rid of unused (not rarely used) indexes. I will come to the rarely used later. According to the query posted in my first comment I have 1222 unused indexes and if I am right according to Wilfred's query 109 rarely used indexes.