This is question 2 of 2 related to the
FAST query hint. Background Information (as an aside, I'm not trying to garner more rep, I'm trying to be true to only asking one question per question).
Our legacy ERP was running on SQL Server 2000 EE and now it's on 2008 R2 EE. We're noticing many more blocked commands in the 2008R2 environment. The 2008R2 environment is running with trace flag 4199 and 1119.
I noticed a difference between the MSDN documentation on hints in 2000) vs. 2008R2 where the
FAST hint is expanded to note that the result will continue to be processed once the specified
n rows had been returned. Is this just a more robust document, is this a change in behavior for this hint through the years, or something different?