tigertoolbox
tigertoolbox copied to clipboard
usp_AdaptiveIndexDefrag / Error converting data type bigint to numeric
This seems to be happening during collection of statistics, leaving the defragmentation effort incomplete.
Selecting a statistic to update...
Getting information on selected statistic...
Determining modification row counter for statistic [...] on table or view [...] of DB [...]...
Using sys.dm_db_stats_properties DMF...
Error 8114 has occurred while determining row modification counter. Message: Error converting data type bigint to numeric. (Line Number: 0)
Found a row modification counter of 0.000 and 332 rows...
No need to update statistic [...] on DB [...] and object [...]...
The relevant table has a field of type bigint
which seems to be where the conflict is originating from.
Without a fix for this the tool cannot be used efficiently.