Another Random Record Selection Method

By Bill Graziano on 6 January 2002 | 0 Comments | Tags: Randomness


Dutch submitted "Yet an other method to random select a records from a database. However this method does not use a temporary table, which has a lot of overhead when you're dealing with large tables." Follow the link to Another Random Record Selection Method...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Using NEWID to Randomly Sort Records (16 April 2002)

Multiple Random Records w/Single Select (4 October 2000)

Returning a Single Random Row (27 September 2000)

Returning Rows in Random Order - Part III - Practical Applications (12 September 2000)

Returning Rows in Random Order - Part II - Revenge of the Randomizer (11 September 2000)

Other Recent Forum Posts

Corrupted mdf file causing the backup job to fail (2 Replies)

Command line variable (0 Replies)

Partitioning existing Databas (2 Replies)

Problem when importing from Excel (3 Replies)

Pivot Table (1 Reply)

Select Statement (6 Replies)

DBCC CHECKDB Failed with 1203 (0 Replies)

CTE Duplicate Issue (4 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -