d-moloney

usp_AdaptiveIndexDefrag question about 'Not partition number specific'

4

I am receiving the message Not partition number specific.. On a SQL 2017 database server. Any insight on why I get this message. I tried looking at the code, but...

usp_AdaptiveIndexDefrag - Error 911 being reported when debug mode = 1

2

Declare @ErrorNo Integer EXECUTE @ErrorNo=[dbo].[usp_AdaptiveIndexDefrag] @timelimit=720, @outputResults =1, @debugMode=1,@forceRescan=1 print @ErrorNo if (@ErrorNo

usp_AdaptiveIndexDefrag - Database does not exist error on SQL 2017 database.

2

Selecting a statistic to update... Getting information on selected statistic... Determining modification row counter for statistic [PK_spotlight_playback_data] on table or view [spotlight_playback_data] of DB [SpotlightPlaybackDatabase]... Using sys.dm_db_stats_properties DMF... Error 911...

usp_AdaptiveIndexDefrag QUOTENAME(@dbName) issue

1

When @DebugMode =1 you have a few commands that contain QUOTENAME(@dbName) which are causing errors Error 911 has occurred while determining row modification counter. Message: Database '[WAREHOUSE_STAGE]' does not exist....

usp_whatsup error Msg 6841, Level 16, State 1, Line 1

1

I tried out usp_whatsup on a SQL 2016 (13.0.5337.0) received the error. Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()'...

Is there a way to Exclude tables from being analyzed, updated, etc? It would be nice to have a parameter that would accept a list that indicated a specific list...

Error 515 has occurred. Message: Cannot insert the value NULL into column 'objectID',

3

I am getting errors on a few database servers. Error 515 has occurred. Message: Cannot insert the value NULL into column 'objectID', table 'Tools.dbo.tbl_AdaptiveIndexDefrag_Stats_log'; column does not allow nulls. INSERT...

**Description of the issue** i am trying to run IndexOptimize and exclude multiple tables. Its only skipping the first one. **SQL Server version and edition** Microsoft SQL Server 2019 (RTM-CU21)...