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.
Syntax:
DBCC SHOWCONTIG
[
(table_name[,index_name])
]
For Example :
DBCC SHOWCONTIG (STUD,STUD_INDEX)
Here, STUD is table and STUD_INDEX is index on table...