 |
|
 |
My Account
|
|
| Home |
|
| Events |
| Current Events |
| Past Events |
| SQL Immersion Events |
| Event Log |
|
| Services |
| Mentoring |
| Custom Courses |
|
| Resources |
| Articles |
| Blogs |
| Books |
| Event Resources |
| Knowledge Base Articles |
| Q & A |
| SQL Scripts |
| Useful Links |
| Whitepapers |
|
| Partners |
|
| Communications |
|
| Contact Us |
|
 |
|
| Index Defragmentation Best Practices in SQL Server 2005 | |
|
Microsoft Tech*Ed Conference Session, 75 Minutes Written/Presented by Kimberly L. Tripp, SQLskills.com Even when properly created (and with the right strategies based on data usage patterns) indexes can lose their effectiveness over time due to fragmentation through inserts, updates and deletes. In this session you will learn the effect of data modifications on indexes and how to clean up the fragmentation. Index fragmentation can negatively impact query performance, require more IOs in large scans and even require more time and space for backups. The effects fragmentation ripple through the database; did you know there are multiple ways to defragment? Did you know that each method provides different pros and cons in terms of maintenance, availability, log space and time? Are you aware of the new features offered by SQL Server 2005 that can offer improved availability while defragmenting tables? Come to this session to make your indexing best practices complete and keep your performance optimal over time. |
|
Privacy Policy. All Rights Reserved. ©2007 SYSolutions, Inc. |
|