Yes, as far as checking to see if indexes are being used, you can use the DMVs so see what's being used.

This blog post can help: http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx