Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    Funny for the day:

    http://www.rd.com/funny-stuff/work-cartoons/%5B/url%5D

    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 9:35 am

    #1896191

  • RE: AlwaysOn failback after DR

    JarJar (8/18/2016)

    Brandie Tarvin (8/18/2016)

    Does that make sense?

    absolutely! Thanks a lot.

    You are welcome.

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

    #1896160

  • RE: Execution Plan Question

    Grant Fritchey (8/18/2016)

    Brandie, go home.

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

    August 18, 2016 at 7:57 am

    #1896158

  • RE: Are the posted questions getting worse?

    ThomasRushton (8/18/2016)

    Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"

    erm... SELECT GETDATE()

    Thanks Jeff!...

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

    #1896138

  • RE: Execution Plan Question

    Ed Wagner (8/18/2016)

    Well, Brandie, I guess I'm happy and sad for you. You didn't get to figure out the puzzle, but it isn't a problem for you any more.

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

    #1896134

  • 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

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