Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Durant Stairway to SQL Server Indexes: Step 12, Create Alter Drop RE: Stairway to SQL Server Indexes: Step 12, Create Alter Drop

  • February 17, 2012 at 2:36 am

    #1448340

    phelmer (6/21/2011)

    When an index is created on that table (clustered or non-clustered), the command returns to the client very quickly to say "Completed successfully". It can't possibly have built the index already, right? So, if that assertion is correct, how can I tell if a particular index has been completely built? Is there a DMV for that? Something in profiler?

    When you get the 'command completed successfully', the index is completely built. It's not a process that can happen in the background

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass