Quote Originally Posted by GaryMazzone View Post
I would use the NEWID() method along with a count and figure out what perecntage of records you want (use a TOP X)
I tried that on a large table, couple million rows, and it chugged along for quite a while. I didn't time it but a couple of minutes at least.