|
-
Sep 29th, 2010, 08:00 AM
#5
Re: Method to select statistically random rows from SQL server
 Originally Posted by GaryMazzone
I would use the NEWID() method along with a count and figure out what perecntage of records you want (use a TOP X)
I tried that on a large table, couple million rows, and it chugged along for quite a while. I didn't time it but a couple of minutes at least.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|