This is one of the three alerts I received:
Hi Mister Magoo,
A new comment on How can I generate random numbers that sum will be x? was posted by Jeff Moden on SQL Server Q&A from the SQL Server Central community:
One more thing. If you nest the inner loop in an explicit transaction old performance trick to accompany the SET NOCOUNT ON trick for loops), the code runs almost 28% faster still. Gotta say it again, nice job, Magoo.
View the new comment