Results from How to Think in Sets – SQL Saturday Sioux Falls 2017

Test #Test NameRun time, ms
11Cursor13,962
12Cursor ROFF10,035
13While Loop8,545
14Set-based140
20Subquery in SELECT3,974
21Rewrite as APPLY3,049
22Rewrite using #temp837
23Rewrite as RowNum446
24Subquery in WHERE2,881
25Rewrite as APPLY2,862
26Rewrite using #temp1,294
27Rewrite as RowNum221
30Scalar UDF Data Access183,561
31Scalar UDF Constant112
32Multi-statement TVF194,591
33CLR184,538
34APPLY1,833
35Inline TVF1,968
36RowNum243
40Running Total - Cursor4,743
41Running Total - Triangle Join100,000,000
42Running Total -
Windowing
539
50SSIS - Command Component3,642
51SSIS - Staging382
60C# Singleton Insert851
61C# SqlBulkCopy67