ReIndexing

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
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_kjmsoftware.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
>
|||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/archives/12-Humpty-Dumpty-Sat-On-A-Wall...html
Tracy McKibben
MCDBA
http://www.realsqlguy.com