April 10, 2012 at 8:04 pm
Comments posted to this topic are about the item Auto compression all indexs on all online db
April 27, 2012 at 6:47 am
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?
April 27, 2012 at 8:12 am
The script was executed without errors?
The master db is present object: SP [dbo].[dba_indexCompression]?
Execute as: EXEC [master].[dbo].[Index_Compression]
October 6, 2015 at 7:56 am
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?
May 10, 2016 at 1:52 pm
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