Today I find out the next sentece in SQL 2012
EXEC sp_indexoption ‘XXX.YYY’, ‘disallowpagelocks’, TRUE
This database is has been migrated recently, was previously in version 2005, but we have done an upgrade to 2012. The issue is that looking on Technet where recommended not to use or avoid, where possible using this function, since it could disappear in future releases. This is one of the problems customize performance optimization. The recommended alternative is to use ALTER INDEX.
Please refer at Technet Microsoft SP_IndexOption
HTH – Antonio NAVARRO
Advertisements