QuestionQ101

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL database named SQLDb1 that contains the resources displayed in the following table.

Question Image

Column1 stores JSON data.

You need to compress Column1 while minimizing the amount of storage used.

What should you use?

Explanation

COMPRESS() accepts nvarchar(max) input and uses the GZIP algorithm, returning the compressed data as varbinary(max). This directly compresses the JSON payload and is appropriate for reducing storage for the column’s values. COMPRESS (Transact-SQL)

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!