April 23, 2010 at 11:39 am
how the fragment and defragment was done in index
April 23, 2010 at 12:54 pm
Not sure what you are asking here, care to elaborate a bit more?
April 25, 2010 at 11:52 pm
mvm_mca07 (4/23/2010)
how the fragment and defragment was done in index
Insert/Update/Deletes cause index fragmentation.
Alter index rebuild/reorganize is used to defragment index.
May 3, 2010 at 1:46 am
okay..i understood now.
May 3, 2010 at 5:03 am
mvm_mca07 (4/23/2010)
how the fragment and defragment was done in index
Refer this http://www.sql-server-performance.com/articles/per/detect_fragmentation_sql2000_sql2005_p1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply