4 ms·
I once used `SELECT TOP 1` ... `ORDER BY NEWID()` to pick a record from a table of millions. Millions of UUIDs generated! All so one would randomly be picked a
by billpg 2y ago
I once used `SELECT TOP 1` ... `ORDER BY NEWID()` to pick a record from a table of millions.
Millions of UUIDs generated! All so one would randomly be picked as the lowest valued and the attached record returned. Such a waste!