Open KMD-jcu opened 3 days ago
Description of the issue
When using the option
@Resumable='Y'
The script generates sql to rebuild the index using resumable syntax - very nice! But this syntax is not allowed on filtered indexes,
SQL Server version and edition Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 2 2024 15:39:01 Copyright (C) 2022 Microsoft Corporation
Version of the script
What command are you executing?
EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y', @Indexes = 'ALL_INDEXES', @MaxDOP = 4, @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REBUILD_ONLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @Resumable='Y'
What output are you getting? Rebuild using Resumable is not allowed for filtered index... (cannot find the exact words....)
Description of the issue
When using the option
@Resumable='Y'
The script generates sql to rebuild the index using resumable syntax - very nice! But this syntax is not allowed on filtered indexes,
SQL Server version and edition Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 2 2024 15:39:01 Copyright (C) 2022 Microsoft Corporation
Version of the script
--// Source: https://ola.hallengren.com //-- --// License: https://ola.hallengren.com/license.html //-- --// GitHub: https://github.com/olahallengren/sql-server-maintenance-solution //-- --// Version: 2020-12-31 18:58:56 //--
What command are you executing?
EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y', @Indexes = 'ALL_INDEXES', @MaxDOP = 4, @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REBUILD_ONLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @Resumable='Y'
What output are you getting? Rebuild using Resumable is not allowed for filtered index... (cannot find the exact words....)