T-SQL & ScriptsSelecting Rows Randomly from a Large Tablehttp://msdn.microsoft.com/en-us/library/cc441928.aspx1 2 3 4 SELECT * FROM Table1 WHERE (ABS(CAST( (BINARY_CHECKSUM(*) * RAND()) as int)) % 100) < 10 -- Percent SELECT * FROM Table1 TABLESAMPLE (1 percent) ORDER BY NEWID()