http://blogs.msdn.com/craigfr/archive/2009/03/04/optimizing-i-o-performance-by-sorting-part-2.aspxIn my last post, I discussed how SQL Server can use sorts to transform random I/Os into sequential I/Os. In this post, I'll demonstrate directly how such a sort can impact performance. For the following experiments, I'll use the same 3 GByte databaseenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2009/03/04/optimizing-i-o-performance-by-sorting-part-2.aspx#9458731Wed, 04 Mar 2009 20:47:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:9458731Click &amp; Solve &raquo; Optimizing I/O Performance by Sorting ??? Part 2 <p>PingBack from <a rel="nofollow" target="_new" href="http://www.clickandsolve.com/?p=17808">http://www.clickandsolve.com/?p=17808</a></p> http://blogs.msdn.com/craigfr/archive/2009/03/04/optimizing-i-o-performance-by-sorting-part-2.aspx#9486998Wed, 18 Mar 2009 17:43:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:9486998Craig 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>