A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.
AI OnAI Off
Re-organize SQL Server indexes and why ALLOW_PAGE_LOCKS is OFF?
Hi!
Our SQL Server admin tried to set up jobs for re-organizing/re-building sql server indexes for our epi commerce databases. Found out that ALLOW_PAGE_LOCKS was set to OFF for indexes, which means they cannot be re-organized (only re-built). A nightly job re-organizing indexes otherwise seems like a good thing to do.
I guess there is a reason for this (guessing dead lock issues?) and wonder if it is safe to set ALLOW_PAGE_LOCKS = ON for all indexes?
Thanks for your input :-)
/ Markus