Forum Replies Created

Viewing 15 posts - 7,681 through 7,695 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/13/2010)

    Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow...

    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.

    August 13, 2010 at 11:28 am

    #1206817

  • RE: Finding Unique Non-Repeating Random Numbers

    Jeff Moden (8/13/2010)

    AndyC London (8/12/2010)

    Other functions to play with with regards to generating test data are the HashBytes function and CHECKSUM function which both have the useful property of being...

    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.

    August 13, 2010 at 7:58 am

    #1206649

  • RE: Finding Unique Non-Repeating Random Numbers

    Jeff Moden (8/13/2010)

    You can see that an average of about 520 numbers out of the million duplicate on each run. The run above (not including the dupe check) takes...

    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.

    August 13, 2010 at 7:56 am

    #1206647

  • RE: Finding Unique Non-Repeating Random Numbers

    Jeff Moden (8/13/2010)

    wppatton (8/12/2010)

    Jim,

    It's not even close to being a homework problem. I wouldn't post homework for someone else to do. It's real world problem being brought to me...

    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.

    August 13, 2010 at 7:55 am

    #1206645

  • RE: Finding Unique Non-Repeating Random Numbers

    shad-873858 (8/12/2010)

    You will get much higher degree of uniqueness if you look at the least significant digits of your RAND() instead of the most significant.

    In your Tally solution, simply changing...

    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.

    August 13, 2010 at 7:54 am

    #1206644

  • RE: Are the posted questions getting worse?

    Gail & Paul, that's for the clarification.

    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.

    August 12, 2010 at 8:23 am

    #1206040

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (8/12/2010)

    Thats 2 things learnt today 🙂

    Kwit larnin' things! That ain't what this here site be for!

    😀

    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.

    August 12, 2010 at 7:41 am

    #1206011

  • RE: Are the posted questions getting worse?

    Paul White NZ (8/12/2010)

    Dave Ballantyne (8/12/2010)

    So if you want to use an index you generally have to use a hint.

    What sort of hint did you have in mind? Index...

    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.

    August 12, 2010 at 7:40 am

    #1206009

  • RE: Where are you?

    Holland is a province in the Netherlands. It isn't the whole country.

    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.

    August 12, 2010 at 7:25 am

    #1205995

  • RE: Finding Unique Non-Repeating Random Numbers

    wppatton (8/12/2010)

    Jim,

    It's not even close to being a homework problem. I wouldn't post homework for someone else to do. It's real world problem being brought to me by a...

    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.

    August 12, 2010 at 7:23 am

    #1205992

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/12/2010)

    Jack Corbett (8/12/2010)

    My kids start school today. I can't believe how early school starts in FL. We are starting earlier than most other schools, but still,...

    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.

    August 12, 2010 at 7:19 am

    #1205989

  • RE: Are the posted questions getting worse?

    Back on topic, someone decided to post a request for T-SQL problem solution in the commentary of the new article I wrote. Did the whole "Here's my problem. Solve it...

    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.

    August 12, 2010 at 7:18 am

    #1205987

  • RE: Are the posted questions getting worse?

    I just have to say:

    Us'n Mid-WESTerners ain't got akcents. @=)

    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.

    August 12, 2010 at 4:32 am

    #1205903

  • RE: Finding Unique Non-Repeating Random Numbers

    alexander.schaaf (8/12/2010)

    Why would the amount of columns have anything to do with it?

    (Did you create an Index on the TaxID column?)

    Answering the questions backwards:

    2) No, I did not create...

    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.

    August 12, 2010 at 4:28 am

    #1205900

  • RE: Finding Unique Non-Repeating Random Numbers

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

    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.

    August 12, 2010 at 4:24 am

    #1205898

Viewing 15 posts - 7,681 through 7,695 (of 9,720 total)