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 100x row counts (n=1,000) in 859 milliseconds |
SQL Server parse and compile time:
CPU time = 859 ms, elapsed time = 859 ms.
Table '#test_fnNumbers_row_counts__________________________________________________________________________________________0000000001FD'. 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 = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
Performance Summary |
---|
fnTally inserted 100x row counts (n=1,000) in 10063 milliseconds |
SQL Server parse and compile time:
CPU time = 8062 ms, elapsed time = 10046 ms.
Table '#test_fnTally_row_counts____________________________________________________________________________________________0000000001FE'. 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.