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

HTH – Antonio NAVARRO

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s