THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Are values generated by NewId() distributed evenly?
I ran a quick check, and it looks like a reasonably even distribution to me. I genenerated 2M NewId values, as follows: SELECT NewID() AS RandomColumn INTO #t FROM Data.TableWith2Mrows I looked at the distribution into 256 buckets, considering the first byte of the value only. All 256 buckets had values: SELECT ...
May 14, 2009
Brought to you by