Search SSWUG.ORG:

DATABASES

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