Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 9,722 total)

  • RE: SSIS inserts are very slow

    jcrawf02 (11/3/2011)

    I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it seems staging tables and updates...

    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, 2011 at 1:03 pm

    #1402888

  • RE: SSIS inserts are very slow

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task instead, use a stored procedure...

    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, 2011 at 12:22 pm

    #1402861

  • RE: SSIS inserts are very slow

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    ricer (11/3/2011)

    Is the GUID your clustered index key as well?

    If so you are probably seeing lots of page splits when you are doing inserts.

    I fail 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.

    November 3, 2011 at 12:19 pm

    #1402853

  • RE: Odd, Intermittent Error in Dataflow

    Jack Corbett (11/3/2011)

    I've never used the multi-cast, I'll have to look at it as it might be a better way to handle this.

    Multicast is a funderful thing. Try it. You...

    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, 2011 at 12:12 pm

    #1402843

  • RE: SSIS inserts are very slow

    ricer (11/3/2011)

    Is the GUID your clustered index key as well?

    If so you are probably seeing lots of page splits when you are doing inserts.

    I fail to see how having 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.

    November 3, 2011 at 12:09 pm

    #1402842

  • RE: Are the posted questions getting worse?

    Quick question. Has anyone else been approached by John Millward of Callidus Technology Limited for permission to use your SQL Articles on a social networking site he's putting together?

    The site...

    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, 2011 at 12:02 pm

    #1402837

  • RE: SSIS inserts are very slow

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    For the two instances you don't require any transformations, don't use the Data Flow task. Using a stored procedure in an Execute SQL Task is much...

    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, 2011 at 11:56 am

    #1402831

  • RE: SSIS inserts are very slow

    For the two instances you don't require any transformations, don't use the Data Flow task. Using a stored procedure in an Execute SQL Task is much faster.

    BTW, what type of...

    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, 2011 at 11:36 am

    #1402820

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/5/2011)

    "How do you return the current date and time from SQL Server using T-SQL?"

    ...

    The answer the interviewee returned was "I don't know... we always used the GUI...

    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, 2011 at 11:32 am

    #1402818

  • RE: Are the posted questions getting worse?

    Sean Lange (10/3/2011)

    This one (http://codevc.com/19244_A_The_WebGrid_Helper_-_Making_Selections.aspx) is a classic. The images are replaced with "Thief" image because they were lifted. The link in the article to "My previous article" even points...

    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, 2011 at 11:24 am

    #1402816

  • RE: Are the posted questions getting worse?

    GilaMonster (10/3/2011)

    SQLRNNR (10/3/2011)

    GilaMonster (10/3/2011)

    It's not the only one.

    http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/with-recompile-and-option-recompile-sql-server-2008.aspx

    http://www.sqlservercentral.com/articles/T-SQL/70809/

    and

    http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/take-an-asp-net-application-offline.aspx

    http://weblogs.asp.net/dotnetstories/archive/2011/09/24/take-an-asp-net-application-offline.aspx

    Wow, this guy is a real class act. I wonder what EMC thinks about it?

    From what I could see (with a few...

    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, 2011 at 11:21 am

    #1402812

  • RE: Are the posted questions getting worse?

    Jack Corbett (10/1/2011)

    Hey guys I got some really cool news today. I was awarded MVP status!

    I just hope I can honor that award the way that all the MVP's...

    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, 2011 at 11:18 am

    #1402809

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (9/30/2011)

    Brandie Tarvin (9/28/2011)

    Speaking of writing, follow this link if you like high fantasy and want to read a story (for free!) from me. http://www.storyportals.com/series/katya-lady-assassin

    Why, yes. This is...

    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, 2011 at 11:16 am

    #1402807

  • RE: Odd, Intermittent Error in Dataflow

    Jack Corbett (9/30/2011)

    What happens is I will get an error for one row that says "An error has occurred while sending this row to destination data source."

    ....

    Oh,...

    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, 2011 at 11:14 am

    #1402803

  • RE: Are the posted questions getting worse?

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    And why is your 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.

    November 3, 2011 at 11:04 am

    #1402795

Viewing 15 posts - 5,161 through 5,175 (of 9,722 total)