Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely...

    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.

    September 16, 2011 at 9:08 am

    #1382602

  • RE: how to trim the value in the table

    Do as I said in the second paragraph of my last post. Import the data as is into a staging table, then split the data up, following the directions 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.

    September 16, 2011 at 7:55 am

    #1382553

  • RE: how to trim the value in the table

    If you are trying to separate the string into multiple strings / columns in Excel, you might look for an Excel forum instead of a SQL forum. If you're trying...

    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.

    September 16, 2011 at 7:49 am

    #1382550

  • RE: Advice on Reducing Database size

    Archiving off data is a good way to reclaim the space for future transactions, but unlike the others, I don't recommend shrinking the files. Shrinking call kill performance and 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.

    September 16, 2011 at 7:44 am

    #1382546

  • RE: insert variable value into table while mapping ssis

    We need a little more information to answer your question.

    How is the variable populated?

    How does the variable relate to the .csv file?

    How is the .csv file getting imported? (what...

    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.

    September 16, 2011 at 7:40 am

    #1382541

  • RE: SSIS Event Handler Duplicates Event

    Really? I had never heard that before.

    I am setting the property and we will see what happens.

    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.

    September 15, 2011 at 12:21 pm

    #1382202

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

    l.danks (9/15/2011)

    To answer one question - the data is entered regularly, every few minutes in fact, but in a format which is less than useless for reporting (just lousy software...

    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.

    September 15, 2011 at 10:50 am

    #1382149

  • RE: SSIS Event Handler Duplicates Event

    How would Delay Validation being set to False force the email to send twice?

    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.

    September 15, 2011 at 6:50 am

    #1381896

  • 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.

    September 15, 2011 at 6:41 am

    #1381887

  • 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.

    September 14, 2011 at 9:36 am

    #1381407

  • 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.

    September 14, 2011 at 9:31 am

    #1381403

  • 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.

    September 14, 2011 at 9:24 am

    #1381393

  • 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.

    September 12, 2011 at 11:33 am

    #1380233

  • 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.

    September 12, 2011 at 10:41 am

    #1380201

  • 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.

    September 9, 2011 at 10:16 am

    #1379389

Viewing 15 posts - 5,251 through 5,265 (of 9,715 total)