Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (3/11/2015)

    Brandie Tarvin (3/10/2015)

    SQLRNNR (3/10/2015)

    Jack Corbett (3/10/2015)

    SQLRNNR (3/9/2015)

    Jack Corbett (3/9/2015)

    Grant Fritchey (3/9/2015)

    By the way, Gianluca is a giant.

    So this means if and when I meet Gianluca...

    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.

    March 11, 2015 at 8:40 am

    #1783315

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/10/2015)

    Jack Corbett (3/10/2015)

    SQLRNNR (3/9/2015)

    Jack Corbett (3/9/2015)

    Grant Fritchey (3/9/2015)

    By the way, Gianluca is a giant.

    So this means if and when I meet Gianluca he'll have 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.

    March 10, 2015 at 12:26 pm

    #1783050

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/9/2015)

    FYI - if you want to speak at the PASS Summit you only have one more week to submit. I submitted 3 sessions this past...

    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.

    March 9, 2015 at 12:11 pm

    #1782666

  • RE: SUM OVER() coming up with different values than CTE query

    dwain.c (3/8/2015)

    I tend to avoid the SUM() OVER and related functions for another reason.

    The Performance of the T-SQL Window Functions[/url]

    Except in cases where a query is really complex already and...

    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.

    March 9, 2015 at 6:26 am

    #1782468

  • RE: SUM OVER() coming up with different values than CTE query

    Turns out I have 244 rows that are sorta duplicated (dups, but not true dups when I look at some of the more unique columns).

    So this means there is yet...

    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.

    March 6, 2015 at 8:51 am

    #1782199

  • RE: SUM OVER() coming up with different values than CTE query

    Eirikur Eiriksson (3/6/2015)

    Quick thought, the difference is mainly that the first code snip implies a group by which translates to a distinct aggregation of each set members by group, 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.

    March 6, 2015 at 8:32 am

    #1782190

  • RE: Joining to tables with bad data

    ps_vbdev (3/5/2015)

    I have a table that holds product prices. It was originally designed to hold historical price values of products but this was abandoned after a few years. So now...

    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.

    March 6, 2015 at 8:08 am

    #1782180

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/5/2015)

    dwain.c (3/5/2015)

    Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not play well with IE11?

    I would say...

    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.

    March 5, 2015 at 8:31 am

    #1781946

  • RE: Are the posted questions getting worse?

    dwain.c (3/5/2015)

    Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not play well with IE11?

    I haven't tried 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.

    March 5, 2015 at 4:43 am

    #1781880

  • RE: Are the posted questions getting worse?

    rodjkidd (3/4/2015)

    Brandie Tarvin (3/4/2015)

    rodjkidd (3/3/2015)

    Brandie Tarvin (3/3/2015)

    rodjkidd (3/3/2015)

    Welcome home Lynn. Enjoy!

    a few hours to kill in London then off to the Excel centre to help with setting up and bag...

    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.

    March 4, 2015 at 4:48 am

    #1781586

  • RE: Weird SQL Job schedule behavior

    GilaMonster (3/3/2015)

    Brandie Tarvin (3/1/2015)

    He changed the schedule to pick up starting tomorrow (3/2/2015)

    Starting three years ago tomorrow, you mean? 🙂

    DOH. I didn't even see 2012. I looked at that...

    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.

    March 4, 2015 at 4:29 am

    #1781576

  • RE: Are the posted questions getting worse?

    rodjkidd (3/3/2015)

    Brandie Tarvin (3/3/2015)

    rodjkidd (3/3/2015)

    Welcome home Lynn. Enjoy!

    a few hours to kill in London then off to the Excel centre to help with setting up and bag packing, etc.

    Safe trips...

    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.

    March 4, 2015 at 4:08 am

    #1781571

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Not to be weird, but...

    YAY! I HAVE MY FIRST SUSPECT DATABASE!

    It's a non-prod reporting database that doesn't get...

    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.

    March 3, 2015 at 5:40 am

    #1781323

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Not to be weird, but...

    YAY! I HAVE MY FIRST SUSPECT DATABASE!

    It's a non-prod reporting database that doesn't get backed up, so now...

    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.

    March 3, 2015 at 5:34 am

    #1781320

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/3/2015)

    Brandie Tarvin (3/3/2015)

    Not to be weird, but...

    YAY! I HAVE MY FIRST SUSPECT DATABASE!

    It's a non-prod reporting database that doesn't get backed up, so now I can really some...

    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.

    March 3, 2015 at 5:22 am

    #1781314

Viewing 15 posts - 2,806 through 2,820 (of 9,725 total)