Forum Replies Created

Viewing 15 posts - 541 through 555 (of 9,725 total)

  • RE: What's wrong with my table?

    Jeff Moden - Monday, October 15, 2018 12:19 PM

    It's official, folks.  The man is NOT an idiot.  Rather, he's quite clever, as I...

    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.

    October 15, 2018 at 12:20 pm

    #2009692

  • RE: Query slow. Help improve?

    SQLStud 74876 - Monday, October 15, 2018 12:04 PM

    Jeff Moden - Saturday, October 13, 2018 10:25 AM

    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.

    October 15, 2018 at 12:19 pm

    #2009691

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 12:04 PM

    Brandie Tarvin - Monday, October 15, 2018 11:07 AM

    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.

    October 15, 2018 at 12:12 pm

    #2009687

  • RE: What's wrong with my table?

    SQLStud 74876 - Monday, October 15, 2018 11:53 AM

    Ahhh man!  You guys are a tough crowd!

    We are trying to help. If you...

    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.

    October 15, 2018 at 12:10 pm

    #2009686

  • RE: Are the posted questions getting worse?

    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.

    October 15, 2018 at 11:40 am

    #2009677

  • RE: Finding recent date from two tables

    Jonathan AC Roberts - Monday, October 15, 2018 11:25 AM

    Brandie Tarvin - Monday, October 15, 2018 11:15...

    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.

    October 15, 2018 at 11:31 am

    #2009675

  • RE: Finding recent date from two tables

    sgmunson - Monday, October 15, 2018 10:19 AM

    salamlemon - Wednesday, October 10, 2018 9:20 PM

    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.

    October 15, 2018 at 11:15 am

    #2009667

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 11:00 AM

    Brandie Tarvin - Monday, October 15, 2018 10:53 AM

    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.

    October 15, 2018 at 11:07 am

    #2009665

  • RE: Is this query correct ?

    Thom A - Monday, October 15, 2018 8:00 AM

    Jonathan AC Roberts - Monday, October 15, 2018 7:51...

    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.

    October 15, 2018 at 11:04 am

    #2009663

  • RE: Are the posted questions getting worse?

    So this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're...

    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.

    October 15, 2018 at 10:53 am

    #2009659

  • RE: Log shipping restore

    Another option to consider is a secondary availability group database. Assuming the instance is clustered, you can set up an AG and it'll always move the transactions without needing to...

    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.

    October 15, 2018 at 10:46 am

    #2009658

  • RE: Talking about SARG

    Well, I'm going to start with Lowell's solution first, on account of these staging tables being wide and long. See how that works. Then maybe later I'll try the self-outer...

    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.

    October 15, 2018 at 10:32 am

    #2009656

  • RE: Talking about SARG

    Thom A - Monday, October 15, 2018 10:01 AM

    Like, Lowell, though, if i'm looking for a specific insurer, I use an OR,...

    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.

    October 15, 2018 at 10:08 am

    #2009649

  • RE: Talking about SARG

    Lowell - Monday, October 15, 2018 9:29 AM

    Brandie I've always done something like this to keep it Sarg-able; does that help? 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.

    October 15, 2018 at 10:02 am

    #2009647

  • RE: Talking about SARG

    ScottPletcher - Monday, October 15, 2018 9:36 AM

    Never use ISNULL() in a JOIN (or WHERE) is a good rule.

    To avoid issues with NULL,...

    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.

    October 15, 2018 at 10:01 am

    #2009646

Viewing 15 posts - 541 through 555 (of 9,725 total)