I 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!!