• Using "ORDER BY CHECKSUM(NEWID())" rather than "ORDER BY NEWID()" apparently produces values with a better random distribution.

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.