Results from How to Think in Sets – SQL Saturday Wausau 2017

Test #Test NameRun time, ms
11Cursor14,055
12Cursor ROFF9,446
13While Loop8,743
14Set-based157
20Subquery in SELECT2,985
21Rewrite as APPLY3,066
22Rewrite using #temp853
23Rewrite as RowNum474
24Subquery in WHERE2,812
25Rewrite as APPLY2,832
26Rewrite using #temp1,311
27Rewrite as RowNum235
30Scalar UDF Data Access183,561
31Scalar UDF Constant100
32Multi-statement TVF194,591
33CLR184,538
34APPLY1,685
35Inline TVF1,787
36RowNum245
40Running Total - Cursor4,974
41Running Total - Triangle Join100,000,000
42Running Total -
Windowing
501
50SSIS - Command Component2,803
51SSIS - Staging329
60C# Singleton Insert600
61C# SqlBulkCopy27