| Test # | Test Name | Run time, ms |
|---|---|---|
| 11 | Cursor | 15,809 |
| 12 | Cursor ROFF | 10,186 |
| 13 | While Loop | 9,163 |
| 14 | Set-based | 161 |
| 20 | Subquery in SELECT | 3,621 |
| 21 | Rewrite as APPLY | 3,144 |
| 22 | Rewrite using #temp | 994 |
| 23 | Rewrite as RowNum | 500 |
| 24 | Subquery in WHERE | 2,903 |
| 25 | Rewrite as APPLY | 2,932 |
| 26 | Rewrite using #temp | 1,547 |
| 27 | Rewrite as RowNum | 224 |
| 30 | Scalar UDF Data Access | 183,561 |
| 31 | Scalar UDF Constant | 104 |
| 32 | Multi-statement TVF | 194,591 |
| 33 | CLR | 184,538 |
| 34 | APPLY | 1,752 |
| 35 | Inline TVF | 1,729 |
| 36 | RowNum | 265 |
| 40 | Running Total - Cursor | 4,980 |
| 41 | Running Total - Triangle Join | ~ 100,000,000 |
| 42 | Running Total - Windowing | 536 |
| 50 | SSIS - Command Component | 3,830 |
| 51 | SSIS - Staging | 271 |
| 60 | C# Singleton Insert | 5,061 |
| 61 | C# SqlBulkCopy | 122 |