Forum Replies Created

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

  • RE: Today's Random Word!

    crookj (8/18/2010)

    dbowlin (8/18/2010)

    motivation

    stimulus

    economic

    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 18, 2010 at 7:56 am

    #1208496

  • RE: Creating history audit table data

    Ray K (8/17/2010)

    Brandie Tarvin (8/17/2010)

    If you can piggy-back your logging table stuff on the code that actually inserts the original data into the table, that would be the best of...

    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 18, 2010 at 7:50 am

    #1208492

  • RE: Creating history audit table data

    If you can piggy-back your logging table stuff on the code that actually inserts the original data into the table, that would be the best of all worlds, IMHO. That...

    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 17, 2010 at 11:38 am

    #1208062

  • RE: Creating history audit table data

    Does it have to be a trigger?

    Could you not change your code that populates the "other" tables into populating this table at the same time? Stored procedures and transactions...

    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 17, 2010 at 11:23 am

    #1208058

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/17/2010)

    Roy Ernest (8/17/2010)

    I am disappointed. I was trying to get Redgate to sponsor a speaker for our user group. They came up with an idea that Brad could...

    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 17, 2010 at 11:20 am

    #1208054

  • RE: Are the posted questions getting worse?

    You know, I've never thought about trying a remote presentation. Now there's an idea to get more speakers "out" to more events.

    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 17, 2010 at 8:34 am

    #1207916

  • RE: Today's Random Word!

    Incorrigible.

    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 17, 2010 at 8:28 am

    #1207911

  • RE: Finding Unique Non-Repeating Random Numbers

    It's not a theoretical exercise. I actually had to do this for a project. And setting up encryption was not an option given me.

    EDIT: Since I had to jump through...

    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:33 am

    #1206821

  • 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

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