Modifying table with large number of records RRS feed

  • Question

  • I have a table with about 400 million rows.  I need to drop a hash column, add some new columns, set them to default of 0, set them to not null, and re add the hash column.  Its taking hours to do this.  Mush of the time is spent recalculating the row hash, I believe.  Are there any techniques i could use to speed up the process?  The DB is using the simple recovery model

    John Schroeder

    • Edited by jschroeder Saturday, October 12, 2019 12:00 AM
    Friday, October 11, 2019 11:57 PM

All replies