Demo SQL Server 2008 Few Outer Row Joins
- Posted: Jun 30, 2009 at 2:35PM
- 9,091 views
Right click “Save as…”
Automatically leverage parallel processing when joining dimensions to the fact table. Each outer row gets a separate thread on a nested loop join and all available cores share the workload.