Forum Replies Created

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

  • 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

  • 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

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