Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 9,715 total)

  • RE: Execution Plan Question

    ChrisM@home (8/17/2016)

    If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data reader operator...

    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 12:18 pm

    #1895999

  • RE: Execution Plan Question

    ChrisM@home (8/17/2016)

    How are rows selected from the big left-joined table - only the join, or is there also a filter in the WHERE clause?

    Only on the join. But it 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.

    August 17, 2016 at 11:30 am

    #1895983

  • RE: Execution Plan Question

    ChrisM@Work (8/17/2016)

    It sounds like one or more of the join columns are missing from whatever index is chosen, which would go some way to explaining the poor row count estimate...

    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 11:16 am

    #1895976

  • RE: Execution Plan Question

    Lowell (8/17/2016)

    whenever the difference between estimated rows and actual rows is off by a lot(order of magnitude or more,

    it usually means the statistics are out of date enough to adversely...

    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 11:14 am

    #1895975

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/17/2016)

    Luis Cazares (8/17/2016)

    Brandie Tarvin (8/17/2016)

    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...

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

    #1895906

  • 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

Viewing 15 posts - 1,516 through 1,530 (of 9,715 total)