Stored Procedure SP_INDEXOPTION In SQL Server 2012

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





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s