Random Selects

The simple things are often the best. Like this way of selecting a random row from a table.

SELECT *
FROM MyTable
ORDER BY NEWID()