Anyone know how to query the list of SQL Server indexes with the following index property settings?
SORT_IN_TEMPDB = ON
DROP_EXISTING = ON
RESUMABLE = ON
ONLINE = ON
MAX_DURATION > 0 mins
MAXDOP <> 0
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql?view=sql-server-ver16#syntax-for-sql-server-azure-sql-database-azure-sql-managed-instance
Found another thread that helps with such queries, but not seeing anything that points to where these props are stored (not really looking for feedback on whether the combination of these settings are good/bad/etc).
List of all index & index columns in SQL Server DB
6