InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:40:12 GMT20http://www.sqlservercentral.com/Forums/Topic3581-84-1.aspx<P><FONT style="BACKGROUND-COLOR: #c0dcc0">Nice article, I especially near the end where real world experience is discussed. I personally would like to see real world comparison between nolock and readpast, but maybe that's another article. </FONT></P><P><FONT style="BACKGROUND-COLOR: #c0dcc0">In some places the article correctly attributes decision-making to the optimizer, but in a few places I think the article misleads by attributing optimization decisions to the Query Analyzer: "<STRONG>Table Hint May Not Be Used By Query Analyzer"</STRONG>, "the query analyzer will often choose ...", "the query analyzer's preference for indexed views...", and "Another reason the query analyzer may ignore...." Substitute "optimizer" for "Query Analyzer" and problem goes away.<FONT style="BACKGROUND-COLOR: #c0dcc0"></FONT></P></FONT>Thu, 15 Apr 2004 03:54:00 GMTMike Goodhttp://www.sqlservercentral.com/Forums/Topic3581-84-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/RDyess/tablehints.asp>http://www.sqlservercentral.com/columnists/RDyess/tablehints.asp</A>Sun, 14 Apr 2002 00:00:00 GMTRandy_Dyess