Home Forums SQL Server 2008 SQL Server 2008 Administration Automate Data Compression RE: Automate Data Compression

  • July 9, 2014 at 7:41 am

    #1728047

    maybe this for the size requirement:

    WHERE

    (convert(varchar,((sys.dm_db_partition_stats.used_page_count*8)/1048576))>10)