tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

usp_AdaptiveIndexDefrag_Exceptions.sql ignoring spaces in table names

Open d4nix-cz opened this issue 5 years ago • 0 comments

Hi, the usp_AdaptiveIndexDefrag_Exceptions.sql procedure removing spaces in table names, see the reference: https://github.com/microsoft/tigertoolbox/blob/0160f5e346582cdfadfed4b37daad87dfe31fa2b/AdaptiveIndexDefrag/usp_AdaptiveIndexDefrag.sql#L3279 My proposal is to replace "REPLACE(@exceptionMask_tables, ' ', ''): with "@exceptionMask_tables" only.

I know its not a good idea to have spaces in table names, but the Navision programers ignoring this advice =)

d4nix-cz avatar Apr 20 '20 15:04 d4nix-cz