add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
The inline table valued funtion (itvf) fnNumbers returns bigint and can generate n of up to 4^16


The inline table valued funtion (itvf) fnNumbersRC returns bigint and can generate n of up to 4^16
Performance Summary
fnNumbers inserted 100x row counts (n=1,000) in 1891 milliseconds 
SQL Server parse and compile time: 
   CPU time = 953 ms, elapsed time = 1874 ms.
Table '#test_fnNumbers_row_counts__________________________________________________________________________________________0000000001E3'. Scan count 0, logical reads 100, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.

 SQL Server Execution Times:
   CPU time = 16 ms,  elapsed time = 15 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.
Performance Summary
fnNumbersRC inserted 100x row counts (n=1,000) in 3484 milliseconds 
SQL Server parse and compile time: 
   CPU time = 78 ms, elapsed time = 78 ms.
Table '#test_fnNumbersRC_row_counts________________________________________________________________________________________0000000001E4'. Scan count 0, logical reads 100, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Table 'Worktable'. Scan count 200, logical reads 600100, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.

 SQL Server Execution Times:
   CPU time = 3109 ms,  elapsed time = 3406 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.