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