Adaptive Index Defrag

In scenario number 8 . usp_AdaptiveIndexDefrag_Exclusions , which is will help in setting on which days (if any) you allow for a specific index, or even all indexes on a given table, to be defragmented. In the previous post here (https://blogs.msdn.microsoft.com/b/blogdoezequiel/archive/2011/03/10/sql-swiss-army-knife-7-adaptive-index-defrag.aspx) there was an example query of how you could set the exclusions embedded in the script, but due to some feedback, I’ve turned it into an SP. This sproc takes 4 input parameters: • @exclusionMask_DB , enter only one database name at a time. • @exclusionMask_days , enter weekdays in short form, between commas. Keep only relevant weekdays on which you DO NOT want to allow defragmentation to occur. Order is not mandatory, but weekday short names are important AS IS ('Sun,Mon,Tue,Wed,Thu,Fri,Sat'). Conversely, leave the default value of NULL to exclude the object(s) from ever being defragged, equivalent to choosing every day of the week. • @exclusionMask_tables (optional) enter table names separated by commas ('table_name_1, table_name_2, table_name_3'). • @exclusionMask_indexes (optional) enter index names separated by commas ('index_name_1, index_name_2, index_name_3'). If you want to exclude all indexes in a given table, enter its name but don't add index names. Now where is this post https://blogs.msdn.microsoft.com/b/blogdoezequiel/archive/2011/03/10/sql-swiss-army-knife-7-adaptive-index-defrag.aspx to see the examples