• Mr Random again....

    tablesample limitations per msdn:

    Rows on individual pages of the table are not correlated with other rows on the same page.

    Never saw a database where that condition could be assumed. most are entered sequentially which is very likley to have correlations.

    newid() and any function of it is "too perfect" the nice properties, such as good distribution of digits, has to be built in.

    true random aren't so perfect exept in very large samples, and good psuedo random should be difficult to distinguish from true random.

    If your doing a lottery, or a statistical study, definately look for better solutions.