Export (0) Print
Expand All
Automate Testing of Your Stored Procs
Streamline Your Database Setup Process with a Custom Installer
Stop SQL Injection Attacks Before They Stop You
Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
AMO Lets You Dig Deeper into Your Data from Your Own Applications
Make Sense of Your Web Feedback using SQL Server 2005
Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
Unearth the New Data Mining Features of Analysis Services 2005
Using XQuery, New Large DataTypes, and More
Expand Minimize
14 out of 19 rated this helpful - Rate this topic

Online Indexing Operations in SQL Server 2005

Published: March 13, 2007

Introduced in SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This paper provides a detailed discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.

Included in this document:

  • Introduction

  • Data Structures and Concepts

  • Overview of the Online Index Build Algorithm

  • Capacity Planning and Concurrency Considerations for Index Create and Rebuild Operations

  • Online Index Best Practices

  • Conclusion

  • Appendix A: Performance Study

  • Appendix B: Diagnostics

  • Appendix C: Log Measurement Script

  • Appendix D: Online Index Limitations

Download

DownloadOnlineIndex.doc
329 KB
Microsoft Word file
Get Office File Viewers

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.