Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

index Expand / Collapse
Author
Message
Posted Friday, April 23, 2010 11:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 3, 2010 2:19 AM
Points: 2, Visits: 5
how the fragment and defragment was done in index
Post #909701
Posted Friday, April 23, 2010 12:54 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 23,081, Visits: 31,621
Not sure what you are asking here, care to elaborate a bit more?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #909765
Posted Sunday, April 25, 2010 11:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
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.
Post #910193
Posted Monday, May 3, 2010 1:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 3, 2010 2:19 AM
Points: 2, Visits: 5
okay..i understood now.
Post #914512
Posted Monday, May 3, 2010 5:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 2,837, Visits: 3,957
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
Post #914578
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse