Forum Replies Created

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

  • RE: Execution Plan Question

    <headdesk>

    So I realized that the date column I'm pulling from history was acting a little funny. We have some dates in August (I.E., the "order" was entered in August but...

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

    #1896124

  • RE: Execution Plan Question

    ChrisM@Work (8/18/2016)

    Brandie Tarvin (8/18/2016)

    Brandie Tarvin (8/18/2016)

    Ed Wagner (8/17/2016)

    I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both 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 18, 2016 at 5:33 am

    #1896114

  • RE: Execution Plan Question

    Brandie Tarvin (8/18/2016)

    Ed Wagner (8/17/2016)

    I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE...

    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 18, 2016 at 5:21 am

    #1896111

  • RE: Execution Plan Question

    Ed Wagner (8/17/2016)

    I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE clauses. ...

    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 18, 2016 at 5:02 am

    #1896108

  • RE: AlwaysOn failback after DR

    JarJar (8/18/2016)

    i think i got it now. this was a missing piece of the puzzle for me. if the db remains in the availability group then it continues 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 18, 2016 at 4:58 am

    #1896104

  • 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

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