SQL Server 2014 Managed Lock Priority for Partition Switch and Online Reindex This is an off-site link.  Please review our Terms of Service for additional information.

(SQLShep) Online reindex and partition switch have both been around for a while now, however one of the biggest issues which still exists is they both require a schema modification lock which is very unfriendly with other locks.

Read this article...

comments powered by Disqus