Forum Replies Created

Viewing 15 posts - 6,541 through 6,555 (of 9,728 total)

  • RE: Today's Random Word!

    CirquedeSQLeil (2/9/2011)

    Histogram

    Diagram

    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.

    February 9, 2011 at 10:41 am

    #1284656

  • RE: Are the posted questions getting worse?

    Actually, I refer to CASE as a statement all the time. Call me lazy. I think I picked up the habit from the programming languages I learned in HS 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.

    February 9, 2011 at 10:40 am

    #1284653

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (2/9/2011)

    You know, I read through that whole thread, and somewhere mid-way I started wondering whether nadabadan himself wasn't actually the interviewer. I guess I am certainly...

    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.

    February 9, 2011 at 10:38 am

    #1284649

  • RE: BCP export with unique file

    An additional note about SSIS, you can multicast the same data to do different destinations at the same time. That's one of the reasons why I like it for situations...

    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.

    February 9, 2011 at 10:35 am

    #1284646

  • RE: Create temp Tbale using SSIS

    What is the error message? Please post 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.

    February 9, 2011 at 10:34 am

    #1284644

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (2/9/2011)

    Handed my notice in today , i can already feel the freedom 🙂

    Actually, that's just the wind blowing up your kilt. @=)

    Seriously, though, are you just moving 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.

    February 9, 2011 at 9:13 am

    #1284574

  • RE: Insuffcient system memory to run this query - sql server 2005 erro

    I'm betting it's a QD problem. I've seen similar problems before and the query you presented us with looks exactly like it was "written" by Query Designer. QD just doesn't...

    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.

    February 9, 2011 at 8:22 am

    #1284517

  • RE: Insuffcient system memory to run this query - sql server 2005 erro

    Are you seeing performance issues with any other processes, views, or queries?

    EDIT: Are you using Query Designer?

    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.

    February 9, 2011 at 8:10 am

    #1284501

  • RE: SSAS not showing all options?

    Nevermind! It's my bad.

    I failed to notice that the ClientIDs are different as well as the ClientNumbers and that some of those IDs are filtered out of the Fact table...

    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.

    February 9, 2011 at 8:05 am

    #1284492

  • RE: Insuffcient system memory to run this query - sql server 2005 erro

    It looks like you've posted your question in the wrong forum. This forum is for backup related issues and your query doesn't look like it's saving backups or doing restores.

    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.

    February 9, 2011 at 7:57 am

    #1284481

  • RE: Taking backup with option "Disk = nul"

    Oh, this sounds like a Question of the Day scenario. One of you should totally send this in.

    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.

    February 9, 2011 at 7:40 am

    #1284467

  • RE: Insuffcient system memory to run this query - sql server 2005 erro

    Post the query you're using and we'll see what we can see.

    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.

    February 9, 2011 at 7:38 am

    #1284464

  • RE: Create temp Tbale using SSIS

    I forgot to ask. What is the exact text of the error you're getting?

    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.

    February 9, 2011 at 7:35 am

    #1284460

  • RE: Performance Best Practices

    One thing that may help (in the long run) is to come up with a DOs and DON'Ts list (Database standards). If you're cleaning up the code, you know 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.

    February 9, 2011 at 7:34 am

    #1284456

  • RE: BCP export with unique file

    I advise using SSIS. You can set up filenames using expressions in SSIS and make it repeatable.

    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.

    February 9, 2011 at 7:30 am

    #1284451

Viewing 15 posts - 6,541 through 6,555 (of 9,728 total)