Forum Replies Created

Viewing 15 posts - 7,621 through 7,635 (of 9,715 total)

  • RE: How to Pivot using T-SQL

    sqlbi (8/27/2010)

    Thirdly, the PIVOT is trying to count a column that doesn't exist in your CTE.

    ---------------------------------------------------------------------------------------------------------------------------

    i changed query as you mentioned above but it is saying invalid emailaddrid

    with...

    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 27, 2010 at 12:07 pm

    #1213168

  • RE: Today's Random Word!

    At least you're not on a plane, Steve. @=)

    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 27, 2010 at 11:53 am

    #1213152

  • RE: Implementing Either This One OR these two Logic

    Wow, Wayne, that's a majorly cool solution. I like.

    The only concern I'd have is scalability, but that's dependent on what the other countries' docs "look like."

    EDIT: Then again, I'm...

    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 27, 2010 at 11:41 am

    #1213136

  • RE: Are the posted questions getting worse?

    WayneS (8/27/2010)

    Sigh. (Bang head on desk).

    How to do troubleshooting 101...

    I'm running a mini session on this for Orlando's upcoming SQL Saturday if anyone's interested. @=)

    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 27, 2010 at 11:31 am

    #1213130

  • RE: How to Pivot using T-SQL

    First, your error message is wrong for your new code. You should be getting 2 errors, not just the 2003 error. And it should be 2009, not 2003, based on...

    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 27, 2010 at 11:29 am

    #1213128

  • RE: Are the posted questions getting worse?

    Ditto on the links thanks. I need to buy myself a copy.

    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 27, 2010 at 9:11 am

    #1213020

  • RE: Are the posted questions getting worse?

    To be fair, there are so many flavors of DBA that architecture / design could be considered part of a DBA's job in certain places.

    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 27, 2010 at 8:32 am

    #1212990

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/27/2010)

    Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀

    ACK! We've been invaded! There's one of those non-DBA types on...

    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 27, 2010 at 7:09 am

    #1212905

  • RE: Are the posted questions getting worse?

    Maybe, but ISTR that it was a reference to SQL Server, not the OS. Because there were questions on how to restore SQL Server with various different backup plans.

    AhHA! I'm...

    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 27, 2010 at 6:15 am

    #1212876

  • RE: Are the posted questions getting worse?

    Odd. I remember studying incremental backups when I took my SQL 2000 cert test. Maybe 2000 got rid of it and SQL 7 had it, but there were incremental backups...

    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 27, 2010 at 5:50 am

    #1212867

  • RE: Today's Random Word!

    verbotten

    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 27, 2010 at 5:41 am

    #1212858

  • RE: Where are you?

    WHoops. Posted in the wrong thread. My bad.

    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 27, 2010 at 5:40 am

    #1212857

  • RE: Implementing Either This One OR these two Logic

    Jack,

    I'll look at the script as soon as I get some free time, but real quick... I know this is a taboo thing to say amongst DBAs, but you may...

    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 27, 2010 at 5:39 am

    #1212856

  • RE: Are the posted questions getting worse?

    GilaMonster (8/26/2010)

    Trey Staker (8/26/2010)

    Alvin Ramard (8/26/2010)

    Q: How would you schedule DB backups to be able to do a point in time recovery?

    A: For example, weekly full backup, daily log backups,...

    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 27, 2010 at 5:36 am

    #1212853

  • RE: Are the posted questions getting worse?

    WayneS (8/26/2010)

    Stefan Krzywicki (8/26/2010)

    On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats,...

    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 27, 2010 at 5:17 am

    #1212846

Viewing 15 posts - 7,621 through 7,635 (of 9,715 total)