Viewing 2 posts - 16 through 17 (of 17 total)
Technically, you still need to issue the ALTER RESOURCE GOVERNER statement in order for the new settings to take effect.
July 31, 2008 at 7:05 am
#851229
Per this article:
http://msdn.microsoft.com/en-us/library/ms188388.aspx
an index cannot be rebuilt with ALLOW_PAGE_LOCKS = OFF. I would venture to say that the rebuild happens one page at a time, locking...
July 25, 2008 at 11:18 am
#848618