SQL Server 2005 DMV - how it can help to consider whether index is useful or not?

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views within SQL Server 2005 version that was lacking in previous versions. The following blog posts covers much of this topic: SQL Server 2005 methods to find table INDEX or Statistics age for better performance DMVs to provide state of TEMPDB during...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2008/02/04/3397.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3397" width="1" height="1">