Compressed folder & Query speed

[CK]

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\)]

"CK" <cf***@hotmail.com> wrote in message
news:43***********************@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/default...b;en-us;231347

[CK]

"Greg D. Moore (Strider)" <mo****************@greenms.com> wrote in message
news:XE****************@newsread1.news.atl.earthli nk.net...

"CK" <cf***@hotmail.com> wrote in message
news:43***********************@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/default...b;en-us;231347