Auto compression all indexs on all online db

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

  • 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?

  • The script was executed without errors?

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

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

  • 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?

  • Thanks for the script.

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

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