Azure SQL Server DBA

What's new in the current version

Question

Automatic index compaction versus traditional index-maintenance jobs on Azure SQL Managed Instance: what changed?

Answer

Automatic index compaction is GA for Managed Instance with the Always-up-to-date update policy and reduces index space consumption automatically. Traditional maintenance is administrator-scheduled. Use automatic compaction where that update policy is acceptable; retain bespoke maintenance for explicit control.

This is 15 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples