Jul 13  

Sometimes this is me

Jeff Moden (3/26/2012)

---

dwain.c (3/26/2012)

---

Outstanding article Jeff! Just what the doctor ordered for something I'm working on at this instant.

I can't wait for the purists to berate you for using "pseudo" random numbers though.

I might be safe for the next 10 minutes or so. Although the "next" random value is certainly predictable, you'd have to know a fair bit about how NEWID() is generated to predict the next value

select abs(checksum(newid())) as RandValue
into RandIDTesting
from sys.all_columns ac1
cross join sys.all_columns ac2 

declare @RangeMin int = 0
declare @RangeMax int = 2147483647
declare @RangeInc int = 65536
declare @RangeCount int = @RangeMax/@RangeInc
select @RangeMin, @RangeMax, @RangeInc, @RangeCount;

with Ranges as (
select top (@RangeCount+1)
	@RangeMin + @RangeInc * (row_number() over (order by (select null))-1) as RangeStart,
	@RangeMin + @RangeInc * (row_number() over (order by (select null)))-1 as RangeEnd
from sys.all_columns ac1
cross join sys.all_columns ac2 
)
select RangeStart, RangeEnd, (select count(*)  from RandIDTesting where RandValue between RangeStart and RangeEnd) as RangeSize
from Ranges
group by RangeStart, RangeEnd
order by RangeStart