| Test # | Test | Runtime (ms) |
|---|---|---|
| 11 | Cursor | 15,378 |
| 12 | Cursor read_only fast_forward | 9,942 |
| 13 | While loop | 8,526 |
| 14 | Set-based | 135 |
| 20 | Subquery (SELECT clause) | 4,285 |
| 21 | Rewrite using APPLY | 3,250 |
| 22 | Rewrite using #temp | 885 |
| 23 | Rewrite using RowNum | 521 |
| 24 | Subquery (WHERE clause) | 3,349 |
| 25 | Rewrite using APPLY | 2,901 |
| 26 | Rewrite using #temp | 1,318 |
| 27 | Rewrite as RowNum | 224 |
| 30 | Scalar UDF with data access | 183,561 |
| 31 | Scalar UDF without data access | 104 |
| 32 | Multi-statement TVF | 194,591 |
| 33 | CLR | 184,538 |
| 34 | APPLY | 1,786 |
| 35 | Inline TVF | 1,927 |
| 36 | RowNum | 276 |
| 40 | Running total - cursor | 4,594 |
| 41 | Running total - triangle join | 100,000,000 |
| 42 | Running total - windowing functions | 526 |
| 60 | C# singleton insert | 4,035 |
| 61 | C# SqlBulkCopy | 95 |