Home > Archive > Microsoft SQL Server forum > November 2005 > Compressed folder & Query speed









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Compressed folder & Query speed
CK

2005-11-20, 3:23 am

One way to save storage space is to put the SQL data files into a compressed
file. Has anyone got any idea how this will affect the query speed?


Greg D. Moore \(Strider\)

2005-11-20, 3:23 am


"CK" <cf276@hotmail.com> wrote in message
news:437fe570$0$7533
6$c30e37c6@ken-reader.news.telstra.net...
> One way to save storage space is to put the SQL data files into a
compressed
> file. Has anyone got any idea how this will affect the query speed?

Do NOT do this.

http://support.microsoft.com/defaul...kb;en-us;231347


>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com