Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Changing the size of a Varchar Field

    We have a small table of about 13 million rows that needs altered. A column in the table needs to be changed from a varchar(20) to a varchar(500). When we ran the alter table script, 3 hrs later and it wasn't done running. Any suggestions on what we can do to speed up the process?

    Thanks ahead of time

    We are running SQL Server 2000 and the db at the time was running in simple mood

  2. #2
    Join Date
    Jan 2004
    Tacoma, Wa
    Bulk copy it out, redefine the table without indexes (except clustered or primary key) or triggers, bulk copy back in with a batchsize set to keep the log from growing too large, reapply the indexes and repost the triggers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts