indexes

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

Re: indexes

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+tab les&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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: indexes

thank you much erland
"Erland Sommarskog" 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+tab les&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/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx