August 1, 2007 at 1:23 am
i am using the Microsoft 2000 and i have mark the un usefull information ti null but the size od the datebase is still the same and i have tried to shrink the database but the size remain the same ............
August 1, 2007 at 1:44 am
Unless you actually need the space on the OS, I would say don't try shrink it as it will take overhead to regrow it.
having said that, what are the columns you have nulled? Everything except varchar will not shrink regardless of the value in the row. Example, an Int will always use 4 bytes. Regardless of it's value. As will a char(10) always use 10. (Except I think, need to confirm, initially, it will be zero (or close to))
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply