Steve Jones - Editor (7/1/2008)
It's likely you would get 10% back, but there's no guarantee.
I tested it more than 10 times and it never returned 10% back approx. It mostly got 476 rows effected or 1454 or 1904 rows.
But, I doubt, does any body uses this in day to day programming? If no, what's the actual use of this function -- "tablesample system".
SQL DBA.