COMPRESS

Question

Post reply

COMPRESS

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
January 19, 2016 at 9:38 pm

#72573

Comments posted to this topic are about the item COMPRESS
January 20, 2016 at 1:31 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Interesting question Steve, thanks. And learned something new.

...

Carlo Romagnano SSC-Insane Points: 22672 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22672

January 20, 2016 at 3:48 am

#1853076

Bellissimo!

😀

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

The SQL Server database engine, replacing application code since 2005... 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

I had never heard of this, probably because I haven't touched SQL 2016. Learned something new, thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Bruce Dow Ten Centuries Points: 1019 More actions · Answer 5

> Correct answer: This function returns a GZip compressed version of the string.

I disagree with the answer.

COMPRESS can return a GZip compressed version of the string, but it does not have to.

According to MSDN https://msdn.microsoft.com/en-us/library/cc280449.aspx

"SQL Server 2016 supports row and page compression for rowstore tables and indexes, and supports columnstore and columnstore archival compression for columnstore tables and indexes."

Also from same article,

"Data can also be compressed using the GZIP algorithm format. This is an additional step and is most suitable for compressing portions of the data when archiving old data for long term storage. "

Irregardless, good question that made me learn something new.

Thanks.

Bruce

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 6

Bruce Dow (1/26/2016)
> Correct answer: This function returns a GZip compressed version of the string.
I disagree with the answer.
COMPRESS can return a GZip compressed version of the string, but it does not have to.
According to MSDN https://msdn.microsoft.com/en-us/library/cc280449.aspx
"SQL Server 2016 supports row and page compression for rowstore tables and indexes, and supports columnstore and columnstore archival compression for columnstore tables and indexes."
Also from same article,
"Data can also be compressed using the GZIP algorithm format. This is an additional step and is most suitable for compressing portions of the data when archiving old data for long term storage. "
Irregardless, good question that made me learn something new.
Thanks.
Bruce

WHile it is true that SQL Server supports all those compression algorithms (and even a few more), that has nothing to do with the question.

The question is about the COMPRESS function. And as you can read on the link in the explanation, that function will always return a GZip compressed version of the input. The other compression methods are used internally but not expised in the COMPRESS function.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

February 25, 2016 at 4:30 pm

#1861275

Wish I was on the newest version.