Data compression

• vsamantha35

  SSChampion

  Points: 11529

  More actions

  July 13, 2018 at 3:40 am

  #373573

  Hi All,

  We have set of large tables and wanted to make use of SQL Server Data Compression feature.
  Is data compression feature is available by default or else is it available on only specific service tier/edition?

  select @@version
  go
  Microsoft SQL Azure (RTM) - 12.0.2000.8 Jun 8 2018 18:18:54 Copyright (C) 2018 Microsoft Corporation

  Thanks,

  Sam

• Grant Fritchey

  SSC Guru

  Points: 398690

  More actions

  July 13, 2018 at 7:44 am

  #1997468

  Here's some great documentation on what's supported within Azure SQL Database for compression. That should fill in all the gaps.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning