tigertoolbox
tigertoolbox copied to clipboard
dbo.usp_AdaptiveIndexDefrag, incorrect definition for @rodmodctr variable
In Stored Procedure dbo.usp_AdaptiveIndexDefrag, the @rodmodctr variable is currently declared as numeric (10,3). Please change its definition to bigint.
This will match its actual definition in the sys.dm_db_stats_properties DMV.
Current definition @rowmodctr NUMERIC(10,3)
Accurate definition @rowmodctr bigint
Having it as numeric(10,3) can cause data conversion issues.