Creating a Uniform, Normal and Benford Law’s Distribution from Random Numbers in SQL Server

Creating test data we often utilise random numbers, within SQL Server we can use the RAND() function or NEWID(). This quick post shows you how to create three different distributions based on the set {1..9} – Uniform (evenly distributed), Normal (distributed about the mean) and Benford – distribution follows Benfords Law of Log10( 1 + […]