Home Forums SQL Server 2008 SQL Server 2008 - General Find All Compressed tables in database - script RE: Find All Compressed tables in database - script

  • December 15, 2014 at 5:03 pm

    #1764829

    FYI:

    WHERE sp.data_compression > 0

    is more sargable then "<> 0"; avoid <> unless you have to use it.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.