http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspxNot everyone knows that query level hints (like loop join) will impact the entirety of a DML query plan. This includes foreign key validation and indexed view maintenance. Let us look at an example with two tables involved in a foreign key constraint.en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#666212Sat, 15 Jul 2006 02:48:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:666212Hints for DML queries » Wagalulu - Microsoft » » Hints for DML queriesPingBack from <a rel="nofollow" target="_new" href="http://microsoft.wagalulu.com/2006/07/14/hints-for-dml-queries/">http://microsoft.wagalulu.com/2006/07/14/hints-for-dml-queries/</a>http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#751502Wed, 13 Sep 2006 06:27:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:751502Julian Kuiters - What I'm Reading 19 July 2006PingBack from <a rel="nofollow" target="_new" href="http://www.julian-kuiters.id.au/article.php/reading-2006-07-19">http://www.julian-kuiters.id.au/article.php/reading-2006-07-19</a>http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#771426Tue, 26 Sep 2006 03:52:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:771426Tips, Tricks, and Advice from the SQL Server Query Processing TeamSince we’re starting a new blog for the whole query processing team, we think it’s appropriate to start...http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#9684402Tue, 02 Jun 2009 10:51:39 GMT91d46819-8472-40ad-a661-2c78acb4018c:9684402 Tips Tricks and Advice from the SQL Server Query Optimization Team | Paid Surveys<p>PingBack from <a rel="nofollow" target="_new" href="http://paidsurveyshub.info/story.php?id=74159">http://paidsurveyshub.info/story.php?id=74159</a></p> http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#9688661Wed, 03 Jun 2009 05:26:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:9688661 Tips Tricks and Advice from the SQL Server Query Optimization Team | Patio Chairs<p>PingBack from <a rel="nofollow" target="_new" href="http://patiochairsite.info/story.php?id=27469">http://patiochairsite.info/story.php?id=27469</a></p> http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx#9717232Tue, 09 Jun 2009 21:46:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:9717232 Tips Tricks and Advice from the SQL Server Query Optimization Team | Weak Bladder<p>PingBack from <a rel="nofollow" target="_new" href="http://weakbladder.info/story.php?id=1682">http://weakbladder.info/story.php?id=1682</a></p>