MS SQL Server - ReIndexing

Author

ReIndexing

Tim Morrison

2006-11-10, 12:12 am

SQL SERVER 2000 & MSDE

We have a commercial app in which the customers will not have any real
computer literate users (software for dummies, who would have thought)

What should I be doing to re-index the database from time to time? There are
around 300 tables.

Does SQL Server take care of this itself or should i have some sort of code
or stored procedure that re-indexes?

TIA

Tim Morrison

Hilary Cotter

2006-11-10, 12:12 am

Check fragmentation and index those tables with appreciable fragmentation.
Look up dbcc showcontig in BOL for an example of such a script.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Tim Morrison" < sales@NOSPAM_kjmsoft
ware.com> wrote in message
news:uKYMrDHBHHA.1196@TK2MSFTNGP02.phx.gbl...
> SQL SERVER 2000 & MSDE
>
> We have a commercial app in which the customers will not have any real
> computer literate users (software for dummies, who would have thought)
>
> What should I be doing to re-index the database from time to time? There
> are around 300 tables.
>
> Does SQL Server take care of this itself or should i have some sort of
> code or stored procedure that re-indexes?
>
> TIA
>
> Tim Morrison
>

Tracy McKibben

2006-11-10, 7:14 pm

Tim Morrison wrote:
> SQL SERVER 2000 & MSDE
>
> We have a commercial app in which the customers will not have any real
> computer literate users (software for dummies, who would have thought)
>
> What should I be doing to re-index the database from time to time? There are
> around 300 tables.
>
> Does SQL Server take care of this itself or should i have some sort of code
> or stored procedure that re-indexes?
>
> TIA
>
> Tim Morrison
>
>

http://realsqlguy.com/serendipity/a...-A-Wall....html

--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Sponsored Links