SQLSACT (2/14/2013)
How does this process differ for Hash Joins?
Why don't you go and read the book that's been recommended several times, do the research and see for yourself?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability