DBCC SHOWCONTIG : SQL SERVER2005
At the time of table or table index fragmented heavily that time we will scan and find out status of table or table index by
DBCC SHOWCONTIG command. Table fragmentation (Fragmentation means joining together) occurs when a large number of
insert and update operations are performed on table.
For Example :
DBCC SHOWCONTIG (STUD,STUD_INDEX)
Here, STUD is table and STUD_INDEX is index on table...