This article is one of the best, most informative I have read on SQL 2000 table indexing. While I have always been able to interpret the output from DBCC ShowContig and act accordingly on the results, I have never fully understood what the relationships between the numbers meant.

Well done Steve Jones and thanks you

Steve Walker

DBA - See Tickets