469,117 Members | 1,366 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,117 developers. It's quick & easy.

Altering tables and database growth

I have a question about altering tables and growth of the database and
transaction log. I have a database which is approximately 35GB. I
had to make a change to a column in the largest table (approximately 7
million rows). I changed this column from varchar(30) to varchar(40).
This column is not in any indexes or involved with any triggers. My
database grew from 35GB to 56GB and my transaction log grew from 9GB
to 25GB. Now all the growth was pure air because I could shrink the
database down right back where it started once the alter completed. I
need to alter 5 more columns in this database table. Are there any
tricks where I can limit the growth of the database? Would it be
faster to pre-expand the database to say 60 or 70GB before doing the
alter?

Thanks in advance,

Dave Serrano.
Jul 20 '05 #1
0 1390

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by dchow | last post: by
68 posts views Thread by rkusenet | last post: by
reply views Thread by Thomas F.O'Connell | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.