Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lemondash
Posting Yak Master
159 Posts |
Posted - 2006-08-15 : 11:24:05
|
Afternoon all,Have an issue with a table that has 8 million rows in it. Now one of the colunm's has a nvarchar length of 511. After a bit of reading up on datatypes i realised that i don't need it to be a nvarchar so ithought i would change it to varchar(ALTER TABLE documentsnew ALTER COLUMN sDescription VARCHAR(510)). But too my horror it has made that table bigger then when i started. Can you help and tell me where i'm going wrongLee |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-15 : 13:17:36
|
Can you give more information about the table being 'bigger'?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-15 : 14:00:12
|
I would believe the log file to grow significantly, not the table.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|