http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspxToday, we'll talk about row goals. The optimizer in SQL Server has a feature that can bias plan choices to retrieve a certain number of rows quickly instead of the whole results. This shows up in a few places, but the primary areas are in TOP N queriesen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#565506Fri, 31 Mar 2006 07:50:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:565506Gaurav BindlishVery cool .... http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#580776Fri, 21 Apr 2006 19:56:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:580776Jerry NixonThere is very little documentation about FAST and how it could be used in the context of an application. Could you point to some more information - Books Online has very little on FAST.http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#595598Thu, 11 May 2006 22:41:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:595598Yukonismhttp://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#771425Tue, 26 Sep 2006 03:52:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:771425Tips, 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/03/30/564912.aspx#6443667Wed, 21 Nov 2007 00:19:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:6443667Web 2.0 - Social Media - Internet News - Blogging » Row Goals in Action<p>PingBack from <a rel="nofollow" target="_new" href="http://hyiplive.org/row-goals-in-action">http://hyiplive.org/row-goals-in-action</a></p> http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#8508187Thu, 15 May 2008 17:56:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:8508187FAST n Query Hint &laquo; Home of the Scary DBA<p>PingBack from <a rel="nofollow" target="_new" href="http://scarydba.wordpress.com/2008/05/15/fast-n-query-hint/">http://scarydba.wordpress.com/2008/05/15/fast-n-query-hint/</a></p> http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx#9763856Wed, 17 Jun 2009 04:34:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:9763856 Tips Tricks and Advice from the SQL Server Query Optimization Team | fix my credit<p>PingBack from <a rel="nofollow" target="_new" href="http://fixmycrediteasily.info/story.php?id=15924">http://fixmycrediteasily.info/story.php?id=15924</a></p>