August 26, 2009 at 1:45 am
what is defragmentation , how to automate the defragmantation , is there any scripts to do ?
replies are highky appreciated
August 26, 2009 at 2:07 am
When you perform constant insert/delete in a table, the associated indexes become fragmented. The process of removing this fragmentation so that index pages become contigous is called defragmentation.
You'll find ample scripts to perform that on this site as well..
August 26, 2009 at 7:58 am
While inserts and updates can cause fragmentation, deletes cannot. Inserts may, or may not cause fragmentation, depending on what the index key is. Updates may cause fragmentation or may not, depending if they increase the size of the row or not.
See - http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply