I just spoke with someone at straightpaths.com who suggested I try this forum. I'm creating a "paths to victory" solution for a series of games where each game has 8 players who will finish 1-8 over a 10-game series. In the interest of working with reasonable numbers, I'm going to isolate the possible outcomes for final two games to identify the winning possibilities for each player with respect to actual results gathered from games 1-8. I'm trying to store the 8!^2 or about 1.6BB outcomes for the two games. I'm running desktop developer edition of the server with MSSMS v18.12. What is the most optimal way to generate the data and commit the result? I have the tempdb and development database on a disk with 400Gb of free storage. I currently have a table with the 40320 (8!) records that enumerate outcomes for 8 players in one game, 1) ABCDEFGH...40320) HGFEDCBA, cross joined on itself to give me possible outcomes for 2 games. Any thoughts on how to go about committing this data would be welcome. Also, if you have ideas on how to optimize this to expand to outcomes for more than two games I'd be interested in hearing this. Thank you!