Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Index Fragmentation and Its Resolution


 Article Abstract:

Find out about index fragmentation and how to correct the issues surrounding it. This article shows what index fragmentation is, how to recognize it and what you can do about it.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Useful Undocumented Informational SQL Server 2005 DBCC Commands
Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
SQL Server 6.5: Some useful undocumented DBCC commands
DBCC Optimization Tips
Useful Undocumented Maintenance SQL Server 2005 DBCC Commands
Working with DBCC INDEXDEFRAG
Useful Undocumented Miscellaneous SQL Server 2005 DBCC Commands
Using DBCC commands to troubleshoot SQL Server problems
Tips for using indexes in SQL Server 2005 (Part 3)



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

Reader Comments: Post Your Comments/Feedback

RE: Index Fragmentation and Its Resolution
(posted: 3/27/2005 4:45:43 PM)
This is a useful article. It helps to know how to interpret the results displayed by the SHOWCONTIG command.


Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004