Re: Data Compression possible in SQL Server?

From: Jim Kennedy (kennedy-downwithspammersfamily_at_attbi.net)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 01:37:26 GMT

"Jack Victor" <Nomail@JustPostReply.tv> wrote in message
news:pan.2004.04.08.16.43.13.279000@JustPostReply.tv...
> sustained inserts at 700-1000 per sec. What is shrink db? Does it
> actually compress the data? I am not worried about db fragmentation. I
> want to be able to compress the records that are going into the database
> so that I am not eating up so much storage.
>
> Thanks
>
> On Wed, 07 Apr 2004 07:41:28
> +0000, mountain man wrote:
>
> > Are you doing 1000 inserts 24x7?
> > Shrinkdb will have overheads but also benefits.
> >
> >
> >
> >
> > "Jack Victor" <Nomail@JustPostReply.tv> wrote in message
> > news:pan.2004.04.07.02.00.34.715000@JustPostReply.tv...
> >> How does shrinking the db impact performance if this is an oltp system
> >> putting in about 1000 inserts per second?
> >>
> >> On Tue, 06 Apr 2004 22:20:39
> >> +0000, mountain man wrote:
> >>
> >> > "Jack Victor" <Nomail@JustPostReply.tv> wrote in message
> >> > news:pan.2004.04.06.20.55.22.734000@JustPostReply.tv...
> >> >> Hi,
> >> >>
> >> >> I'm wondering if it is possible to compress the data in SQL Server.
> > For
> >> >> instance, in Oracle, there are routines you can use in stored
> > procedures
> >> >> to compress and decompress data. Is this possible to do in some way
> > with
> >> >> SQLServer?
> >> >
> >> >
> >> > There is SHRINKDB.
> >> > Via Enterprise Manager,
> >> > select the database,
> >> > right click, all tasks, shrink db
> >> >
> >> > This can be automated.
> >>
>
Jack is referring to a feature where the data is actually compressed
(invisible to the end user) on a row by row basis.
SQL Server does not have this capability.
Jim

Relevant Pages

  • Re: exe compression, crunch and alternatives
    ... I've used UPX and found that it seems to compress ... well while having no noticeable unpacking lag time. ... I can shrink the file or I can shrink the ZIP that it's in, ... I have used Crunch V2 to compress VB6 ...
    (comp.lang.basic.visual.misc)
  • Re: Trip Pictures...Hey Frank
    ... >I do this all the time to shrink my pictures before I put them on the ... Lots of flexibility in how much you choose to compress them ... donb at arcatapet dot com ...
    (rec.outdoors.rv-travel)
  • Re: Data Compression possible in SQL Server?
    ... What is shrink db? ... I am not worried about db fragmentation. ... want to be able to compress the records that are going into the database ... >> How does shrinking the db impact performance if this is an oltp system ...
    (microsoft.public.sqlserver)
  • Re: Data Compression possible in SQL Server?
    ... What is shrink db? ... I am not worried about db fragmentation. ... >want to be able to compress the records that are going into the database ... it's usually far better to just get more storage space. ...
    (microsoft.public.sqlserver)
  • Re: File Compression
    ... > compressed folder it does not shrink much in size. ... Some file types, ... compress them, you get little or no addition savings. ...
    (microsoft.public.windowsxp.basics)
Loading