Shifting gears, I find the formula in Books Online to be inaccurate. The number of rows that it returns varies quite a bit. The following will always return the same number of rows although they will be random. Yeah... it takes longer than the BOL formula but it does return an accurate number of rows in random order. It's also a hell of a lot easier to understand for most people.
SELECT TOP 2.5 PERCENT * FROM Sales.SalesOrderDetail
ORDER BY NEWID()
;
And, yeah... I know this is a six year old thread but I'm answering the question from yesterday. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.