DannyS (3/14/2010)
Ok, this isn't the most elegant solution, but is is a proper "Simple Random Sample" and is very fast
Yes it is neat. If you are interested in a more generic version, but using the same basic idea, check this active thread out:
http://www.sqlservercentral.com/Forums/FindPost882261.aspx
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi