Home Forums SQL Server 2012 SQL 2012 - General DBCC DBREINDEX results in INSERT INTO [table1] SELECT * FROM [table1] RE: DBCC DBREINDEX results in INSERT INTO [table1] SELECT * FROM [table1]

  • August 25, 2014 at 10:19 am

    #1740758

    Maxer (8/25/2014)

    So I wonder why my profiler trace isn't showing that activity, maybe a function of table size or something? (Or I am missing some columns)

    Probably the events your capturing.

    Also,why is DBCC doing that? Does it delete data and re-add it what is the purpose of that statement (the insert all rows from table into self)?

    No deletion. It's creating a new copy of the index.

    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