Question of the Dayhttp://sqlserver.ro/forums/17/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: QOD 70-431 2006-09-20 Objective: Maintaining Databases - Manage index fragmentationhttp://sqlserver.ro/forums/thread/737.aspxSat, 04 Nov 2006 19:40:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:737crestinul0http://sqlserver.ro/forums/thread/737.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=737alter indexQOD 70-431 2006-09-20 Objective: Maintaining Databases - Manage index fragmentationhttp://sqlserver.ro/forums/thread/116.aspxWed, 20 Sep 2006 08:04:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:116xmldeveloper0http://sqlserver.ro/forums/thread/116.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=116<P>What statement allows you to rebuild, reorganize, disable or enable an index in SQL Server 2005 ?</P> <P><A title="ALTER INDEX"><FONT color=#99aa99>Place the mouse cursor HERE for the answer</FONT></A></P> <P>Reference: <A href="http://msdn2.microsoft.com/en-us/library/ms188388.aspx"><FONT color=#99aa99>http://msdn2.microsoft.com/en-us/library/ms188388.aspx</FONT></A></P>