Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brandie Tarvin Finding Unique Non-Repeating Random Numbers RE: Finding Unique Non-Repeating Random Numbers

  • August 12, 2010 at 4:24 am

    #1205898

    Alexander-1013105 (8/12/2010)

    LFSRs are basically very simple, very fast pseudo-random number generators that generate a set of unique, non-repeating (but cyclic) numbers.

    This is possibly not a solution for implementing in T-SQL, but if you're able to use C# (or maybe even C++) assemblies, it might just work for you.

    It's definitely something to keep in mind, but for my solution, I needed T-SQL code since I'm restoring backups to dev environments and "washing" the numbers before letting the developers & testers at the back end data.

    Thanks for the link, though. I like hearing about new stuff.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.