We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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....)
The text was updated successfully, but these errors were encountered:
No branches or pull requests
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....)
The text was updated successfully, but these errors were encountered: