testing with a random id in sql

Mar 19, 07

this isn’t exactly a new tip, but if you don’t know, you can select a random id from a table using the following syntax:

so… if you need to perform random performance tests, you can use #1 below to retrieve a random id and then test against it. example: