How can we help you today? How can we help you today?

Ignore index locking hints

Day one with the beta; looking good so far.

My current issue:
I'd like to be able to ignore the index locking hint: 
WITH (ALLOW_PAGE_LOCKS=OFF)
as its use isn't synchronized between my environments.

I don't want to ignore all index checking, as indexes are one of the primary items I check on.

Suggestion:
It would be useful to be able to ignore these hints.
However as this is quite a specific requirement, it occurs to me that what might be more useful (than another option in the list) is an option to ignore specific strings in the comparison.

e.g. Ignore instances of the string(s): "WITH (ALLOW_PAGE_LOCKS=OFF)"

Either having another option to specifically ignore locking hints, or the more generic string ignore would reduce my mismatch list to "real" differences.

Thanks to the team/co for opening this beta ;)

Campey
campey
0

Comments

1 comment

Sort by
  • Andras B
    Many thanks for suggesting the above option. I have saved this request, and we will consider it for a future version (we are unlikely to include this in version 7.0, but nothing is set into stone).
    If anyone else is affected by the lack of this option, please let us know (the more people need it the sooner it will be in the product :)
    Once again thanks for you feedback,
    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.