469,576 Members | 1,681 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,576 developers. It's quick & easy.

Compressed Drive Support in Yukon (SQL2005)?

Hi,

Can anyone please tell me if there will be support in SQL2005 - Yukon for
datafiles to be placed on Compressed volumes or if there will be
compression of the data that is transparent to the user.

Thanks! <Keeps fingers crossed>
Jack
Jul 20 '05 #1
1 1421
Jack Victor (No****@JustPostReply.tv) writes:
Can anyone please tell me if there will be support in SQL2005 - Yukon for
datafiles to be placed on Compressed volumes or if there will be
compression of the data that is transparent to the user.


I cannot recall having seen anything public about this.

I would also like to point out that support for compressed volumes is very
unlikely to happen. Just how would it work? Compression works on file level
in NTFS. Should SQL Server uncompress the database when it opens and then
compress it when it closes it? But since a database is open most of the
time, what's the point? Or should SQL Server only compress/uncompress on
updates? That would be painfully slow.

Compression of data within SQL Server is possibly something that can happen,
although that I have difficulties to envision a general-purpose compression
scheme that would cover different needs that users may have. This may be an
area where third-party and custom-built solutions will be the answer for
the forseeable future.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Dennis Hotson | last post: by
13 posts views Thread by Leonardo Francalanci | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.