tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

dbo.usp_AdaptiveIndexDefrag, incorrect definition for @rodmodctr variable

Open DanielAdeniji opened this issue 5 years ago • 0 comments

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.

DanielAdeniji avatar Jun 20 '20 18:06 DanielAdeniji