If you want to learn about index defragmentation, read Microsoft SQL Server 2000 Index Defragmentation Best Practices white paper by Mike Ruthruff. I especially liked the part that explains the difference between DBCC DBREINDEX and DBCC INDEXDEFRAG. PS. Is there a more appropriate forum at SQL-Server-Performance for posts like mine? -- Marek Grzenkowicz
I think Contibure Your Performance and Clustering Tips is a better place. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell All postings are provided “AS IS†with no warranties for accuracy.
I was considering this, but I abandoned this idea, since this is not MY tip. But anyway, since you're a moderator, can you move my post? -- Marek Grzenkowicz
I don't see any issues in referring the links or tips provided by others which will be deemed as best practices at times. And if you want to share your exeperience in this regard make use of Weblog in this site, which will be ideal in this regard. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.