The Compression Type

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  November 24, 2020 at 12:00 am

  #3808970

  Comments posted to this topic are about the item The Compression Type

• SQLWinther

  SSCertifiable

  Points: 6294

  More actions

  November 25, 2020 at 8:35 am

  #3813792

  That was an easy question. You can have different compression levels for different partitions of an index and thats why you need to look at sys.partitions. You can also find the number of rows for each partition in sys.partittions. If you want to quickly find out how many records you have in a table, sys.partitions is the fastest source.

  /Håkan Winther
  MCITP:Database Developer 2008
  MCTS: SQL Server 2008, Implementation and Maintenance
  MCSE: Data Platform