Auto compression all indexs on all online db

  • d-i-m-on

    Old Hand

    Points: 321

    Comments posted to this topic are about the item Auto compression all indexs on all online db

  • karabela33

    SSC Rookie

    Points: 31

    when i run the script i get the following error

    Msg 208, Level 16, State 6, Procedure Index_Compression, Line 1

    Invalid object name 'dbo.Index_Compression'.

    i have sql 2012 developer edition installed.

    im missing the procedure Index_Compression.

    could you help me with that?

  • d-i-m-on

    Old Hand

    Points: 321

    The script was executed without errors?

    The master db is present object: SP [dbo].[dba_indexCompression]?

    Execute as: EXEC [master].[dbo].[Index_Compression]

  • SQL Guy 1

    SSCoach

    Points: 15732

    Why not to store dynamic SQL in a varchar(max) variable ? Why you need both temp tables?

    What is the goal to join to sys.database_mirroring ? You're not using anything from it.

    Do you run a research of how much space you save with compression? Maybe you will overspend CPU in sake of meager saving of space?

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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