Re: Data Compression possible in SQL Server?

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

From: mountain man (hobbit_at_southern_seaweed.com.op)
Date: 04/06/04 

Date: Tue, 06 Apr 2004 22:20:39 GMT

"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. 

-- 
Pete Brown
Winluck P/L
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software

Relevant Pages

  • Re: Data Compression possible in SQL Server?
    ... >> I'm wondering if it is possible to compress the data in SQL Server. ... > There is SHRINKDB. ... > Via Enterprise Manager, ... There is no native way to do this in SQL Server. ...
    (microsoft.public.sqlserver)
  • Re: Compressed Indexes and insert operations
    ... I just moved into this opening and ... and just wanted some validation. ... There is essentially no chance you are ever going to compress all ... Oracle Ace Director & Instructor ...
    (comp.databases.oracle.server)
  • Re: Problem with Unix PIPE in my script using oracle export utility
    ... But since the syntax for the datapump is different I ... am finding it difficult to compress the file with the above syntax: ... It seems expdp is removing the destination file and then recreating it. ... You need to find a way to alter it's behavior so the people you need to talk to are at Oracle support or an Oracle forum. ...
    (comp.unix.programmer)
  • scp in a multi-piped command?
    ... passing it through gzip or compress | ... gzip -d or uncompress on the other end | ... It is very straightforward to take an Oracle export and pipe it to ... I have read on how to set up ssh in batch mode and am pretty confident ...
    (comp.security.ssh)
  • Re: Import extent size problems
    ... statement on the big database said ... size if compress is N? ... to see what Oracle believes the storage parameters to be. ...
    (comp.databases.oracle.server)