SQL Server Performance Forum – Threads Archive
Index management 2005
I heard that we can perform online index rebuild activity on SQL 2005.Did any one performed this?
Where exactly it differs from sql2000. if you have any scripts related to this pls post.
siri
Swamy Sirigineedi
Hi,<br />Online Index operations are available only in SQL server 2005 Enterprise Edition.<br />Also to understand online index operation better, I would suggest to go through Books Online.<br />Refer to:<br />1>How Online Index Operations Work <br />2>Guidelines for Performing Online Index Operations.<br />3><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />erforming Index Operations Online <br /><br />So it differs from SQL2000 in a way that, <br />FROM BOL:<br />in 2005 for example, while a clustered index is being rebuilt by one user, that user and others can continue to update and query the underlying data
If the table contains LOB datatype columns you can’t perform online indexing… SQL Server 2005 Books Online
Guidelines for Performing Online Index Operations
http://msdn2.microsoft.com/en-gb/library/ms190981.aspx
Mohammed U.
I have used in my environment and before that referred the same link by Mohammed previously, but you need to consider this carefully and do not apply to all the indexes. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>