PhilM-IT

don't suppose there is any plan to update the code to address this scenario. We just came across the same problem. Luckly we're using clustered so we can try this...

The detail @christillman references is correct. It's a little confusing as this SQL leads to different percentages than what SSMS shows users in the UI. A while back I built...

This was also updated recently... https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15 "Starting with SQL Server 2019 (15.x), Azure SQL Database, and Azure SQL Managed Instance, the tuple-mover is helped by a background merge task that...