http://blogs.msdn.com/craigfr/archive/2008/10/07/random-prefetching.aspxIn my last post , I explained the importance of asynchronous I/O and described how SQL Server uses sequential read ahead to boost the performance of scans. In this post, I'll discuss how SQL Server uses random prefetching. Let's begin with a simple exampleenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2008/10/07/random-prefetching.aspx#9486999Wed, 18 Mar 2009 17:43:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:9486999Craig Freedman's SQL Server Blog<p>In my past two posts, I explained how SQL Server may add a sort to the outer side of a nested loops join</p>