>Try setting it up as a job based on the Michelle Ufford's script or Olla's script. So, it will automatically detect problematic indexes and re-build them as needed.
>
>BTW, I'm reading right now (finished) this blog post
>
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/sql-server-dba-tip-missing-index-dmv>
>and it has a link to another interesting post (even if I don't remember it) by Brad Schulz.
This one is a first timer for me. I never had that situation before. To me, this looks like the index became unusable. It is like as if it became corrupted. I thought this was bullet proof in SQL Server. I am just trying to find the reason which has triggered that situation.
Thanks for the reference