Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 9,722 total)

  • RE: Insert Into temp table and then copy into 'real' table

    A couple of things.

    1) If you're deleting everything from the destination, use TRUNCATE rather than DELETE. TRUNCATE generally runs faster because it does not fully log the rows being...

    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.

  • RE: You'd think I'd have learned...

    Ninja's_RGR'us (9/14/2011)


    Brandie Tarvin (9/14/2011)


    Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was...

    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.

  • RE: You'd think I'd have learned...

    Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was a rationalist, wasn'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.

  • RE: You'd think I'd have learned...

    Ray K (9/14/2011)


    True story: a few weeks ago, I was administering a final exam (I teach part-time). One of my students asked a question. It went something like...

    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.

  • RE: BIDS - Uncouple Variables and Toolbox

    You rock, Dave23! Your Google-Fu is superior to mine.

    That actually worked. I moved my Toolbox and no error when I closed BIDS. I open it up and it's exactly 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.

  • RE: BIDS - Uncouple Variables and Toolbox

    After experimenting several times, I finally noticed a pattern. If I close BIDS out as normal (without moving the Toolbox), everything shuts down fine, no issues.

    If I move the Toolbox...

    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.

  • RE: BIDS ForEach Enumerator is Blank

    HowardW (9/9/2011)


    Actually, this is definitely a UI bug. It looks like it's selected when you create a new one, but it's not behind the scenes.

    Are you having the same...

    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.

  • RE: BIDS ForEach Enumerator is Blank

    Howard, that's brilliant! It worked.

    Thank you so very much. I was about to start developing in 2005 and then upgrade.

    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.

  • RE: BIDS - Uncouple Variables and Toolbox

    And yet, it's not permanent. The Toolbox keeps moving back to the bottom of my screen when I restart VS.

    This is annoying!

    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.

  • RE: Mass Add of SSRS Columns

    Bleargh. I hate using the Wizard. It always gets things wrong.

    Edit: Thanks for the suggestion, though.

    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.

  • RE: How to ensure a job only runs for a set duration?

    So far as I know, you can't.

    You could test rebuilding various indexes, though, and break the job up into smaller parts, only running one of those parts each day. 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.

  • RE: SSIS Error in Job

    Jack Corbett (9/8/2011)


    You don't have a package configuration somewhere that is overwriting the design-time value do you? It sounds like that could be it since having a different name...

    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.

  • RE: SSIS Error in Job

    Already saw that MSDN post last week. As I mentioned it in the first post of this thread, I didn't find anything when I searched for it.

    Unfortunately, I can'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.

  • RE: Are the posted questions getting worse?

    Best wishes for your father, Jack. I know how you feel. I have close relatives who trip just by looking at a corner and are breaking all sorts of things...

    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.

  • RE: SSIS Error in Job

    I've narrowed it down to a name change issue.

    If I leave the connection manager named ServerName.DatabaseName, it stays as the 10 client. But as soon as I remove the servername...

    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.

Viewing 15 posts - 5,266 through 5,280 (of 9,722 total)