Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: What impact to add a column to a big table?

    Hello, everyone:

    I want to add a column, INT NOT NULL DEFAULT 0, to a table. There are about 9 mil. records, 57 columns in the table. SQL 2k on Win 2003. What impact maybe bring?

    1) Is there a down time on database and server?
    2) Is it possible to insert records during adding new column?
    3) How long will be taken roughly?

    Thanks a lot.

    ZYT

  2. #2
    Join Date
    Jan 2005
    Posts
    165
    We only have about 1.5 million records in our largest table and it took our server (2x 64-bit 3.0 GHz Xeon, 6GB RAM, 15k RPM SCSI) about 2-3 seconds.

    I had no downtime, and a few beta testers were using the database.

Posting Permissions

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