One of the speakers at the European PASS Conference 2010 pointed out that Kimberly Tripp has written sp_helpindex2, an extended version of sp_helpindex that does show included columns and filters on indexes.
This can be really helpful in just taking a complete look at all your indexes. Read the blog at http://www.sqlskills.com/blogs/Kimberly/post/sp_helpindex2-to-show-included-columns-(20052b)-and-filtered-indexes-(2008)-which-are-not-shown-by-sp_helpindex.aspx
posted @ Friday, April 23, 2010 6:27 PM