Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 9,725 total)

  • RE: AlwaysOn failback after DR

    JarJar (8/17/2016)

    i'm not clear on something about the AlwaysOn failback.... say we failover to our DR site after an outage on our primary site. the outage lasts 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 17, 2016 at 7:05 am

    #1895904

  • RE: Are the posted questions getting worse?

    Huh...

    So I'm troubleshooting code that goes over a linked server. I've pulled it down to our non-prod environment, removed the linked server name from the code, and am running 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 17, 2016 at 6:30 am

    #1895892

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/17/2016)

    BrainDonor (8/17/2016)

    ChrisM@Work (8/17/2016)

    We have git hubs all over the UK. They're also known as Weatherspoons.

    You owe me a new keyboard...

    😀

    ...just managed to save mine

    😎

    I have apparently missed 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.

    August 17, 2016 at 6:27 am

    #1895891

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/16/2016)

    Brandie Tarvin (8/16/2016)

    Has anyone here used GitHub?

    If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be...

    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, 2016 at 6:26 am

    #1895890

  • RE: Advice needed - troubleshooting Severity 20 errors

    WilburBud (8/12/2016)

    Hi Brandie,

    I get similar log entries when our security folks are running scans:

    Error: 17836, Severity: 20, State: 17.

    Length specified in network packet payload did not match number of bytes...

    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 16, 2016 at 7:35 am

    #1895643

  • RE: Advice needed - troubleshooting Severity 20 errors

    Ahha!

    I had a coworker look into this also. He determined (and called our network team to verify) that it is "network scans from the switches" that is causing this. They...

    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 16, 2016 at 7:33 am

    #1895642

  • RE: Are the posted questions getting worse?

    And, on another note, guess what I'm rolling back today?

    Sigh. You only have 10 days post install, folks. It's a new "feature" in the Anniversary update.

    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 16, 2016 at 6:13 am

    #1895610

  • RE: Are the posted questions getting worse?

    Has anyone here used GitHub?

    If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?

    We're apparently getting it at 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.

    August 16, 2016 at 5:50 am

    #1895603

  • RE: Questions on spills to tempdb

    ThomasRushton (8/15/2016)

    GilaMonster (8/11/2016)

    Brandie Tarvin (8/11/2016)

    3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against...

    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 15, 2016 at 12:46 pm

    #1895503

  • RE: Questions on spills to tempdb

    GilaMonster (8/11/2016)

    Brandie Tarvin (8/11/2016)

    3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against 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 15, 2016 at 9:06 am

    #1895464

  • RE: Questions on spills to tempdb

    I don't think I've ever seen a spill warning before I moved to SQL 2012. Now I seem to be spotting them all over the place. I really wish 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.

    August 15, 2016 at 8:59 am

    #1895461

  • RE: Are the posted questions getting worse?

    TomThomson (8/11/2016)

    Lynn Pettis (8/11/2016)

    Brandie Tarvin (8/11/2016)

    SQLRNNR (8/10/2016)

    Brandie Tarvin (8/10/2016)

    Sean Lange (8/10/2016)

    Brandie Tarvin (8/10/2016)

    SQLRNNR (8/9/2016)

    Brandie Tarvin (8/9/2016)

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of 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, 2016 at 7:31 am

    #1895213

  • RE: Advice needed - troubleshooting Severity 20 errors

    Brandie Tarvin (8/10/2016)

    Luis Cazares (8/9/2016)

    Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?

    No. Because my Google-Fu didn't uncover this page. Thanks for the link. I'll check 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, 2016 at 5:35 am

    #1895194

  • RE: How do you manage your junior DBA

    Steve Jones - SSC Editor (8/11/2016)

    S7 (8/10/2016)

    Thanks, Operational dba. The person didn't have a dba background but came from application support. I'm a senior DBA and the person was hired...

    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 11, 2016 at 10:27 am

    #1895054

  • RE: How do you manage your junior DBA

    A few things to consider. Does the junior DBA need some mentoring? Is this a go-getter type of person or someone who just sits around waiting for other people 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.

    August 11, 2016 at 8:55 am

    #1895015

Viewing 15 posts - 1,531 through 1,545 (of 9,725 total)