Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (9/28/2016)

    Reposting from twitter:

    "I'm looking for examples of extremely big or extremely busy relational database systems doesn't have to be SQL Server."

    Case studies or similar, don't need detail, just

    It's...

    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.

    September 28, 2016 at 11:38 am

    #1903726

  • RE: Are the posted questions getting worse?

    J Livingston SQL (9/27/2016)

    drew.allen (9/27/2016)

    Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime....

    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.

    September 28, 2016 at 4:17 am

    #1903579

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (9/27/2016)

    You verified the programming worked as designed.

    Maybe you could offer to look at their testing scenarios to see why this was not discovered several years ago.

    Ha. He just...

    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.

    September 27, 2016 at 8:25 am

    #1903357

  • RE: Are the posted questions getting worse?

    SET RANT Brandie ON;

    I just spent the past week working on a bug fix to get into our production systems before month end. Last night, after I leave for the...

    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.

    September 27, 2016 at 5:08 am

    #1903288

  • RE: Are the posted questions getting worse?

    Microsoft seems to be adopting the attitude of "one size fits all" OS management. If they worried about their marketshare before, they're really going to be worrying about it now....

    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.

    September 27, 2016 at 5:03 am

    #1903286

  • RE: Cleaning up "rotten" tables - need help with code

    Jeff Moden (9/22/2016)

    I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View...

    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.

    September 27, 2016 at 4:59 am

    #1903285

  • RE: Looking to update old code

    I'll keep this all in mind. Thanks, everyone.

    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.

    September 27, 2016 at 4:55 am

    #1903284

  • RE: Are the posted questions getting worse?

    HELLO! This is my new "must have".

    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.

    September 26, 2016 at 7:17 am

    #1903076

  • RE: Are the posted questions getting worse?

    TomThomson (9/24/2016)

    Jeff Moden (9/23/2016)

    Luis Cazares (9/23/2016)

    Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.

    No... you're not grumpy. As a matter 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.

    September 26, 2016 at 7:16 am

    #1903075

  • RE: Looking to update old code

    Eric M Russell (9/23/2016)

    Brandie Tarvin (9/22/2016)

    Eric M Russell (9/16/2016)

    If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other...

    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.

    September 23, 2016 at 12:28 pm

    #1902895

  • RE: Looking to update old code

    The Dixie Flatline (9/22/2016)

    Brandie Tarvin (9/22/2016)

    The Dixie Flatline (9/15/2016)

    If some of your joins are to tables that simply provide descriptions, I'm a big fan of converting those joins to inline...

    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.

    September 23, 2016 at 11:36 am

    #1902878

  • RE: Are the posted questions getting worse?

    YIKES! Not only is Microsoft changing the patching for Win 7 & 8.1, but hackers have gotten to the White House.

    And we're having mini-meltdowns at work where everyone is...

    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.

    September 23, 2016 at 10:40 am

    #1902857

  • RE: Cleaning up "rotten" tables - need help with code

    Phil Parkin (9/22/2016)

    Brandie Tarvin (9/22/2016)

    Thanks, guys. But you're all missing the point of my question.

    I withdraw it since no one understands what I'm asking for.

    Yep, I am totally puzzled...

    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.

    September 22, 2016 at 10:39 am

    #1902547

  • RE: Cleaning up "rotten" tables - need help with code

    mister.magoo (9/22/2016)

    I would:

    Change the process so it doesn't generate empty tables.

    Yeah, already doing that.

    Open Object Explorer Details, right click column headers and include "Row Count" in the display

    Sort list by...

    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.

    September 22, 2016 at 9:59 am

    #1902525

  • RE: Cleaning up "rotten" tables - need help with code

    Thanks, guys. But you're all missing the point of my question.

    I withdraw it since no one understands what I'm asking 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.

    September 22, 2016 at 9:58 am

    #1902522

Viewing 15 posts - 1,441 through 1,455 (of 9,725 total)