Virtual Happy Hour is canceled this month (March) due to Good Friday.
Try our conversational search powered by Generative AI!
AI OnAI Off
Virtual Happy Hour is canceled this month (March) due to Good Friday.
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