Re: Shrinking varchar column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jack (anonymous_at_discussions.microsoft.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 11:10:21 -0700

Here it is.

rows reserved data index_size unused
66939819 10505848 KB 5921928 KB 4584760 KB -840 KB

>-----Original Message-----
>Can you show the results of
>
>EXEC sp_spaceused
>EXEC sp_spaceused 'that_table_name'
>
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>
>
>"Jack" <anonymous@discussions.microsoft.com> wrote in
message
>news:199ee01c44d7f$e1461b70$a301280a@phx.gbl...
>> I have a varchar (2500) column in a table looks like
>> occupying the most of over 10 GB data. Most of the rows
in
>> this column is empty. There is no index on this column.
>> How can I shrink this table (Particularly this column)?.
>> Would
>>
>> Update Mytable
>> Set col1 = LTRIM (RTRIM (col1))
>>
>> help ?
>>
>> Thanks for any feedback.......
>
>
>.
>