Posted by Greg D. Moore \(Strider\) on 10/31/05 02:36

"Gordowey" <albertoiriarte@gmail.com> wrote in message
news:1130717670.681491.136070@g47g2000cwa.googlegroups.com...
> I have the next question, and i would like to hear what do you think
> about, and if is there a better solution for "my problem"
>
> here is the question, I have a huge table with 60GB of data (image
> files). The problem happen always when i try to ALTER the structure of
> the table. For example I change a field char(3) to char(4)...the
> sqlserver then performs the "alter table" command...that must be
> something similar than "insert into the new table + drop the actual
> table" and for that I need about 60GB o space for my LOG file, and
> takes hours to complete the operation.


Sounds about right.

>
> Is this the only way to alter a single field in my table??

Well, you might be able to ADD a new column to your table, that might work
better. (especially if it has no default).

Or, it might be easier to BCP the data out, truncate the table, BCP the data
in.

(in this case I don't think native format would work so you'd have to
experiment.)


>
> I would like to heard you opinions...Thanks..
>
> ALberto
>

[Back to original message]