In short adding, modifying, and deleting data causes fragmentation. I googled it to see what I could come up with. Here is a pretty good link on managing fragmentation: http://mssqltips.com/tip.asp?tip=1165
--- "Dudley, Joelie" <[EMAIL PROTECTED]> wrote: > Question for you SQL gurus out there. > > MS SQL 2000 - what makes database tables get fragmented? Is it > normal > for this to occur? > > Any help on this would be greatly appreciated as our Remedy SQL > database > has hundreds of fragmented table. > > Thanks, > > Joelie Dudley > Application Developer > 555 Walnut Street > 7th Floor, Forum Place > Harrisburg, PA 17110 > Phone: (717) 772-8143 > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where the Answers Are" > K. R. Gallagher Mailto: [EMAIL PROTECTED] http://www.krgallagher.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
