Learning to Think in Sets – Results from DevSpace Conference 2017

Test #TestRuntime (ms)
11Cursor15,378
12Cursor read_only fast_forward9,942
13While loop8,526
14Set-based135
20Subquery (SELECT clause)4,285
21Rewrite using APPLY3,250
22Rewrite using #temp885
23Rewrite using RowNum521
24Subquery (WHERE clause)3,349
25Rewrite using APPLY2,901
26Rewrite using #temp1,318
27Rewrite as RowNum224
30Scalar UDF with data access183,561
31Scalar UDF without data access104
32Multi-statement TVF194,591
33CLR184,538
34APPLY1,786
35Inline TVF1,927
36RowNum276
40Running total - cursor4,594
41Running total - triangle join100,000,000
42Running total - windowing functions526
60C# singleton insert4,035
61C# SqlBulkCopy95