How to control online Index Rebuild Locking using SQL Server 2014 Managed Lock Priority

When you perform a SQL Server Online Index Rebuild operation, introduced for the first time in SQL Server 2005, the index will not be taken down. But at a specific point, in which the new index new is built and switched from the old structure of the index, a special kind of lock, Schema Modification … Continue reading How to control online Index Rebuild Locking using SQL Server 2014 Managed Lock Priority