"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99AAF398D854AYazorman@127.0.0.1...
> DaveP (dvs_bis@sbcglobal.net) writes:
>
>> where can i find a example on how to
>> build a script to reindex all my tables
>
> http://www.google.se/search?hl=sv&q=build+script+reindex+tables&btnG=S%C3%B6k&meta=
>
> You could also look in Books Online for the definition of sysindexes and
> sysobjects if you are on SQL 2000 or sys.objects and sys.indexes if you
> are on SQL 2005.
>
> One thing to be careful with is that if fragmentation is below 30%, there
> is
> not so much to gain with reindexing, so adding some intelligence to handle
> this may be worth it. I don't have any example at hand, but the hits on
> Google may give you something.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

> where can i find a example on how to
> build a script to reindex all my tables