The Compression Type

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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

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