Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    ThomasRushton (8/19/2016)

    ChrisM@Work (8/18/2016)

    Brandie Tarvin (8/18/2016)

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

    August 19, 2016 at 6:36 am

    #1896336

  • RE: Execution Plan Question

    jasona.work (8/18/2016)

    Brandie Tarvin (8/18/2016)

    Grant Fritchey (8/18/2016)

    Brandie, go home.

    Thank you.

    Wait!

    Before you go, can you work on this one little problem, it should be a quick thing, please?

    :hehe:

    GAAAAAHHHHHH!!!!

    Stop impersonating my users! Or...

    August 18, 2016 at 9:40 am

    #1896195

  • RE: Are the posted questions getting worse?

    Funny for the day:

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

    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.

    August 18, 2016 at 7:58 am

    #1896160

  • RE: Execution Plan Question

    Grant Fritchey (8/18/2016)

    Brandie, go home.

    Thank you.

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

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

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

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

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

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

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

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

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

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

    August 17, 2016 at 11:16 am

    #1895976

Viewing 15 posts - 1,501 through 1,515 (of 9,715 total)