• Ok, that tells a tale of a much smaller table than what you were showing before.

    I bet there was blocking, or memory thrashing, or slow io, or any number of issues that could crop up due to resource use while trying to create that index.

    You can use sp_who2 as a quick means to identify blocking on a query such as creating an index.

    The total free space (from that query) is in MB.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events