To get 1000 random rows from a table, the standard trick is
SELECT TOP 1000 * FROM tbl ORDER BY newid()
Bear in mind that for a big table, SQL Server will read all rows, so it can be expensive. A leaner alternative is
SELECT * FROM tbl TABLESAMPLE (1000 ROWS)
But this is less random, as SQL Server will read all rows on a couple of pages. And the number of rows may not be exactly 1000.