Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to updates and delets on the table and the golden rule is that to have relevant indexes for better performance. As you may aware that indexes involve both a maintenance cost and a read benefit, the overall index cost benefit can be determined by comparing...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/07/31/1197.aspx