• Regarding compressed tables/ data-

    PAGE compression gives more compression ratio than ROW compression.

    Page compression uses the actual logic for compression. Row compression happens only on fixed length data types.