Re: Data Compression possible in SQL Server?

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

Date: Sun, 02 May 2004 08:39:24 GMT

"Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
news:q5ikc.1077$ts3.88130@attbi_s02...
> "Jack Victor" <Nomail@JustPostReply.tv> wrote in message

> 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

Thanks, someone else also pointed this out. I made the assumption
that the issue related to physical disk space.

If this is in fact the case, a review the efficiency of the data types
used in these high volume tables might be rewarding, in the
absence of any further advice.

SQL Server does have the capability to uniquely establish the
storeage space per data type, and if an application and data
types have been inherited, they may not be efficient.

A once-off gain in disk space, but you never know until you
examine the specifications what can be gained here. In
some cases the gain is substantial, due to the
large rowcounts of the tables.

Best wishes 

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

Relevant Pages

  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • Documenting Tables and Queries
    ... I am completely new to SQL Server, ... MSDE2000 on the way to re-writing a MS Access 2000 app into a Visual ... I have not been able to find a similar capability within SQL Server. ... concept and the syntax or language structure. ...
    (microsoft.public.sqlserver.tools)
  • Re: Java method invocation support
    ... provides this capability based on the article at ... The short answer is no but you get .NET in SQL Server 2005. ... code in T-SQL or write an "extended stored procedure". ... marketing-wise is the same as Oracle's Java capabilities. ...
    (comp.databases.ms-sqlserver)
  • Re: Datatype for storing serialized class instance in database
    ... SQL Server does not have the capability of representing such complex data ...
    (microsoft.public.sqlserver.programming)
Loading