It seems like there is a bit of consensus that CLR is not a go-to tool, especially for high transaction databases. When it is use, it is mostly for text...

Ok, this isn't the most elegant solution, but is is a proper "Simple Random Sample" and is very fast

/*

FAST Simple Random Sample from a source table using pseudo random number...

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...

The values generated have some nice properties, but aren't random.

Converting the first 8 digits to an integer, hex2dec(left([guid],8)), the numbers have definate correlation with the previous generated value, and the...

GUID and SQL Server function Newid() create globally unique identifiers. This is not they same as random and likely does not have very good random properties.

One digit (16 bits) is...

Newb here, but saw CLR poll.

I've used CLR a bit for a database backed website. Used lots of simple function usually for text processing for example,

a function to determine if...

I don't know the properties of newid, and any function on an unknown source of entropy can cause problems if you'll looking for true randomnous rather than just a simple...