Updating rows in sql
The tablesample was the best answer for me as I was doing a complex query on a very large table. I did get a variation in the number records returned as I ran this multiple times but all of them were within an acceptable margin of error.
Otherwise,you might specify the additional search criteria in a way that produces incorrect results.
Delete From Statement The DELETE FROM statement in SQL is used to remove records from a table.
Please note that the DELETE FROM command cannot delete any rows of data that would violate FOREIGN KEY or other constraints.
TABLESAMPLE() is good from a performance standpoint, but you will get clumping of results (all rows on a page will be returned).
For a better performing true random sample, the best way is to filter out rows randomly.