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 512 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).

Automate Database Defragmentation and Statistics Updates


 Article Abstract:

(Ben Taylor) For a high volume database it is important to schedule maintenance tasks during off-peak times. This article provides source and explanation for a method of automating the updating of statistics, indexes and reorganizing your tables resulting in optimum performance. This utility assesses the current status of all the tables in your database and only modifies those table which are outside a user configured threshold.

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

SQL Server 7.0: index statistics details
Optimizer Statistics for Newbies
Undocumented SQL Server 2005 Database Maintenance Plan Stored Procedures
Troubleshooting Database Maintenance Plan Wizard
SQL Server 6.5: index statistics details
Troubleshooting Performance Monitor
Updating Statistics to Assure Performance
Performance Monitor Optimization Tips
Taming DB2 Performance Issues



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

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

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