General information
Forum:
Microsoft SQL Server
>Hi Guys,
>
>I used to have a database that is about 6GB in size. Most of the datatypes on the tables are char() and I decided to change them into varchar().
>I was able to shrunk a 6GB database to 3GB by changing the Char datatypes to VarChar. I did this by creating an identical database with the fields data type set to VarChar and then Exporting the data from the original database.
>
>The setup was fine for about a week until we found a glaring increase in the size of the database. in a span of 3 days, the database grew up to 5 GB. Is there a logical explanation on how it ended up acquiring to much space?
>
>Please advice
>
>Thanks....
Is varchar data trimmed ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only