Re: Issue with a table that is 75%-80% of the database size

From: mitra fatolahi (anonymous_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 11:46:53 -0700

Here is a sample data:

id_col size_col content_col

1 24 Please review the notes.
2 46 Please email or call me when you
                         hear from Bob.
3 59 Did you hear the new news
                         about John moving to a new place.

We are storing the message body of emails in text in the
content column.
Please note the issue with this table seems to be that we
have too many rows (millions or billions)that leads to
75%-80% of the size of the database.

Thank you,

-Mitra

>-----Original Message-----
>
>
>"mitra fatolahi" <anonymous@discussions.microsoft.com>
wrote in message
>news:2ddf01c48eb9$45515ab0$a601280a@phx.gbl...
>>
>> This table is normalized.
>
> What are you storing in the contents column? Please
post a few rows of
>sample data.
>
>
>.
>