Random Data
I needed this a while ago, and again today. It's time to blog it so I've got somewhere to look it up from :)
If you ever need to get rows returned from SQL Server in a random order, something like this works a treat:
SELECT *
FROM Northwind..Orders
ORDER BY NEWID()
It's the call to NEWID() that does the trick.