InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:27:29 GMT20http://www.sqlservercentral.com/Forums/Topic428381-146-1.aspxYes, 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.aspxSat, 01 Dec 2007 14:27:18 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic428381-146-1.aspxThanks Steve. Guess what I told this to an interview but he still wanted to see what else we can do? I was stuck:)I think there are some system DMVs in 2005 that show statistical information regarding indexes.Regards,Sat, 01 Dec 2007 12:51:14 GMTRazi, Mhttp://www.sqlservercentral.com/Forums/Topic428381-146-1.aspxYou can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.Other than that, SQL Server maintains the indexes fairly well.Sat, 01 Dec 2007 11:54:22 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic428381-146-1.aspxI have a database which has a over 80 to 100 indexes. How do we maintain these indexes, I think re-indexing all of them is not a good idea. Is there any other way of monitoring these indexes in SQL Server 2005 for fragmentation etc. Your insight is appreciated!! Regards,Fri, 30 Nov 2007 17:56:37 GMTRazi, M