In SQL-Server 2005 Microsoft introduced DMVs which are great for index tuning.

Old news, but I have used it a couple of times recently, so I thought I would post a link to this excellent article:

http://www.sql-server-performance.com/articles/per/Identify_Missing_Indexes_Using_SQL_Server_DMVs_p1.aspx