By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
SV.number
INTO dbo.N
FROM master.dbo.spt_values AS SV
WHERE
SV.[type] = N'P'
AND SV.number BETWEEN 1 AND 400;
400 rows affected
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET NOCOUNT ON;
SET STATISTICS IO, TIME OFF;
SET STATISTICS XML OFF;
DECLARE
@s datetime2(7) = SYSUTCDATETIME(),
@n integer = 400;
SELECT
c = COUNT_BIG(*)
FROM dbo.N AS N
CROSS JOIN dbo.N AS N2
CROSS JOIN dbo.N AS N3
WHERE
N.number <= @n
AND N2.number <= @n
AND N3.number <= @n
OPTION
(OPTIMIZE FOR (@n = 1));
SELECT
[Elapsed Time ms] = DATEDIFF(MILLISECOND, @s, SYSUTCDATETIME());
| c |
|---|
| 64000000 |
| Elapsed Time ms |
|---|
| 5921 |