Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    GilaMonster (8/19/2016)

    !!!!

    https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing

    And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.

    Congrats! Nice accomplishment.

    Is this one of their...

    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 19, 2016 at 11:00 am

    #1896399

  • RE: Are the posted questions getting worse?

    I have once again learned the value of being part of a SQL forum. Specifically this site.

    New project. Take a feed I already created and make sure that payments are...

    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 19, 2016 at 9:28 am

    #1896375

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/19/2016)

    And then we have people that think they can learn our job from a book.

    blink

    blinkblink

    Ummmm, that's how I learned it. Books and a small PC and doing 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 19, 2016 at 9:20 am

    #1896372

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

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

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

    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

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