Look below for the difference in the way you use the dbcc showcontig command
--DBCC SHOWCONTIG(TABLE_PROD_RES)
DBCC SHOWCONTIG scanning 'TABLE_PROD_RES' table...
Table: 'TABLE_PROD_RES' (1241211622); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 748041
- Extents Scanned..............................: 93513
- Extent Switches..............................: 93526
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.98% [93506:93527]
- Logical Scan Fragmentation ..................: 0.01%
- Extent Scan Fragmentation ...................: 10.43%
- Avg. Bytes Free per Page.....................: 351.9
- Avg. Page Density (full).....................: 95.65%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
--DBCC SHOWCONTIG(TABLE_PROD_RES) WITH FAST
DBCC SHOWCONTIG scanning 'TABLE_PROD_RES' table...
Table: 'TABLE_PROD_RES' (1241211622); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 748041
- Extent Switches..............................: 93526
- Scan Density [Best Count:Actual Count].......: 99.98% [93506:93527]
- Logical Scan Fragmentation ..................: 0.01%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The WITH FAST doesn't mention the Avg. Page density which is needed if you want to REINDEX with a FILL FACTOR other than 100%, this is applicable if you table is updated quite often and is not static.
If not then 'WITH FAST' is much faster..thanks for showing this QUICK CHECK kinda thing..:)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."