Cliff Jones (2/17/2012)
Interesting but I don't think I want my developers to discover the FORCESEEK hint.
This is completely the wrong approach, in my opinion. I prefer to work with developers to share knowledge rather than hoping they stay in the dark. The most successful places I have worked have all had a healthy relationship between DBAs and developers, with regular sessions for each team to share ideas and techniques. I find that working positively with developers produces benefits for everyone.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi