Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 9,720 total)

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Friday, May 12, 2017 5:47 AM

    If you know the absolute maximum number of rows in the source, you could...

    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.

    May 12, 2017 at 12:00 pm

    #1942376

  • RE: SSIS ForEach Loop Container recursion question

    Eirikur Eiriksson - Friday, May 12, 2017 5:28 AM

    Are you exporting the data from a table?
    😎

    Yes. I've got a table 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.

    May 12, 2017 at 11:59 am

    #1942375

  • RE: SSIS ForEach Loop Container recursion question

    Thanks, Guys. I'm going to watch this thread for a little bit more (I want to hear what Thom has to say) before digging back into this. I've been banging...

    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.

    May 12, 2017 at 5:22 am

    #1942300

  • RE: Are the posted questions getting worse?

    Thanks, Thom.

    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.

    May 12, 2017 at 5:19 am

    #1942299

  • RE: Are the posted questions getting worse?

    I could use a little bit of SSIS brainstorming assistance over here if someone wouldn't mind. This one has me kind of stumped.

    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.

    May 12, 2017 at 5:02 am

    #1942295

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Thursday, May 11, 2017 11:41 AM

    Brandie Tarvin - Tuesday, May 9, 2017 4:47 AM

    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.

    May 12, 2017 at 4:00 am

    #1942292

  • RE: Are the posted questions getting worse?

    FYI: I just got accepted to speak at the 2017 Grace Hopper Conference about Careers in Database Administration. I'm doing the Student Opportunity Labs section of the conference. It's 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.

    May 11, 2017 at 9:06 am

    #1942176

  • RE: Are the posted questions getting worse?

    Sorry, John. I live in the 50 States but did not win a $10 gift card, so I'm the wrong person to ask on both counts.

    On the other...

    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.

    May 11, 2017 at 5:16 am

    #1942135

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    To add on to what the others are saying, all variable columns NVARCHAR and VARCHAR have an additional overhead added to the length you've give them. I believe (Lynn, correct...

    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.

    May 11, 2017 at 4:49 am

    #1942134

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    The reason Gail is asking for the table definition (as in the CREATE TABLE & CREATE INDEX statements) is because we can add up the data types and lengths to...

    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.

    May 10, 2017 at 8:57 am

    #1942027

  • RE: Are the posted questions getting worse?

    My boss broke SQL Server Database Mirroring.

    Well, actually, he's just getting errors when creating a database mirror and asked me to assist, but I really really wanted to...

    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.

    May 10, 2017 at 7:39 am

    #1941996

  • RE: Drop/Create objects versus Alter

    Yeah. It was nice that not only was IT able to come to the same place, but we were able to convince the BU management teams that this was for...

    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.

    May 10, 2017 at 6:45 am

    #1941978

  • RE: Why would SQL throw a Severity 016 alert?? following a successful db restore?

    Is this a production database or non-production? If non-production, do you have another backup with which you can test to see if the same thing 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.

    May 10, 2017 at 6:43 am

    #1941977

  • RE: Drop/Create objects versus Alter

    Sergiy - Tuesday, May 9, 2017 10:27 PM

    I believe she was talking about this:

    The reason being is we had a...

    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.

    May 10, 2017 at 5:39 am

    #1941958

  • RE: Drop/Create objects versus Alter

    Ed Wagner - Tuesday, May 9, 2017 5:23 AM

    Sergiy - Monday, May 8, 2017 7:18 PM

    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.

    May 10, 2017 at 5:27 am

    #1941955

Viewing 15 posts - 1,006 through 1,020 (of 9,720 total)