Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 9,715 total)

  • RE: SQL Server 2005 Maintainaince Plan excution fails

    EDIT: GAH. Wrong thread. Let me go back and re-read.

    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.

    November 15, 2010 at 6:49 am

    #1250686

  • RE: code to select highest in each of several catagories

    Linda 44925 (11/9/2010)

    I'm still confused by why the CTE method is better overall?

    A CTE is not necessarily better overall. I've seen CTEs that kill performance in certain circumstances. Sometimes...

    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.

    November 15, 2010 at 6:41 am

    #1250678

  • RE: Today's Random Word!

    Vacation.

    Over, alas. Back to the desk 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.

    November 15, 2010 at 6:37 am

    #1250676

  • RE: format date within reporting services

    Ali Bajwa (11/5/2010)

    It is pretty simple to set the date format in SSRS if you know how to. Please follow my blog to resolve your issue:

    http://alibajwa.blogspot.com/

    Ali, be careful about...

    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.

    November 15, 2010 at 6:34 am

    #1250673

  • RE: Detective Stories - Changing the Case

    Thanks to everyone who's posted a response. I see I have a lot of testing to do.

    Someone mentioned removing extraneous spaces. In this particular case, there are no "extraneous" spaces....

    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.

    November 15, 2010 at 6:29 am

    #1250667

  • RE: Detective Stories - Changing the Case

    Carl Federl (10/18/2010)

    Perhaps I am missing something but what is wrong with a solution that has no cursors, whiles or UDFs ?

    Maybe I'm misreading your solution, but it doesn't seem...

    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.

    November 15, 2010 at 6:24 am

    #1250662

  • RE: Detective Stories - Changing the Case

    Jan Van der Eecken (10/18/2010)

    Hi Brandie,

    I guess the final update back will fail on a database with a case sensitive collation. Shouldn't it rather read:

    Update idf

    Set Location = mt1.Location

    from dbo.Import_Data_Filter...

    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.

    November 15, 2010 at 6:22 am

    #1250659

  • RE: code to select highest in each of several catagories

    CELKO (11/4/2010)

    Columns are nothing like fields.

    Not necessarily true.

    Talk to a business user once in a while (someone who's used Lotus or Excel or Access) and you will find they...

    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.

    November 4, 2010 at 11:39 am

    #1246727

  • RE: Are the posted questions getting worse?

    And if she chooses not to, a new topic of discussion. I'll start.

    TOPIC: Things you should never tell your parents

    How those footprints *really* got on the ceiling.

    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.

    November 4, 2010 at 11:24 am

    #1246712

  • RE: Where are you?

    pitvax (11/4/2010)

    ... and I am writing from Czech Republic.

    Pit Vax

    Welcome to the group! It's nice to meet people from the international SQL Community.

    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.

    November 4, 2010 at 10:26 am

    #1246664

  • RE: Today's Random Word!

    <headdesk><headdesk>

    New WOTD: groan

    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.

    November 4, 2010 at 7:08 am

    #1246507

  • RE: Today's Random Word!

    Chris Morris-439714 (11/4/2010)

    Brandie Tarvin (11/4/2010)

    Thor

    Do you know the age-old joke about Thor?

    Depends. If you're talking about the Thorsday joke, my father tells it all to frequently. If you're not, do...

    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.

    November 4, 2010 at 6:53 am

    #1246500

  • RE: Today's Random Word!

    Thor

    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.

    November 4, 2010 at 4:40 am

    #1246445

  • RE: Today's Random Word!

    CirquedeSQLeil (11/3/2010)

    crookj (11/3/2010)

    CirquedeSQLeil (11/3/2010)

    Cobra

    GI Joe 😉

    A real American Hero.

    And knowing is half the battle.

    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.

    November 3, 2010 at 8:59 am

    #1246063

  • RE: Today's Random Word!

    Yes.

    @=)

    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.

    November 3, 2010 at 6:07 am

    #1245936

Viewing 15 posts - 7,006 through 7,020 (of 9,715 total)