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
Performance Summary |
---|
fnNumbers inserted 20x row counts (n=1,000) in 125 milliseconds |
SQL Server parse and compile time:
CPU time = 125 ms, elapsed time = 125 ms.
Table '#test_fnNumbers_row_counts__________________________________________________________________________________________0000000001ED'. Scan count 0, logical reads 20, 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 = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
Performance Summary |
---|
fnTally inserted 20x row counts (n=1,000) in 640 milliseconds |
SQL Server parse and compile time:
CPU time = 640 ms, elapsed time = 640 ms.
Table '#test_fnTally_row_counts____________________________________________________________________________________________0000000001EE'. Scan count 0, logical reads 20, 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 = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.