var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What impact to add a column to a big table?
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.
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.