I have a SQL Server 2005 table called BRITTNEY_SPEARS_MARRIAGES
and it has the following columns:
MarrigeId tinyint,
HusbandName varchar(500),
MarrigeLength int
Now I have another table BRITTNEY_SPEARS_MARRIAGE_STORIES
StoryId int,
MarriageId tinyint,
StoryText nvarchar(max)
The problem is we want to update MarrigeId
column to an int
from a tinyint
. We just feel that Brittney is going to have lots of marriages before everything is said and done.
Now the BRITTNEY_SPEARS_MARRIAGE_STORIES
table has 18 million rows in it (hey the girl has some issues) so when we go to do the update the transaction log fills up and our SQL Server box dies.
How can we get around this?
Is there anyway to say "Hey SQL Server I'm going to update this column and make it bigger. Trust me on this SQL Server. Please don't fill up the transaction log while you attempt to validate everything?"