Timeline for How to request a random row in SQL?
Current License: CC BY-SA 3.0
2 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 17, 2023 at 18:18 | comment | added | Jeff Moden | I guess "It Depends". I did a test of both on a 10 Million row, 5.2GB table where the average row size was 530 Bytes and the NEWID() method was 51% faster and used 40% less CPU than the CRYPT_GEN_RANDOM(10) method. | |
Apr 16, 2015 at 13:36 | history | answered | David Knight | CC BY-SA 3.0 |