471,893 Members | 1,311 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 1479

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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.