Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 2,838 total)

  • RE: SSIS inserts are very slow

    Jack Corbett (11/3/2011)

    Stefan Krzywicki (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.

    Best way of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:26 pm

    #1402863

  • RE: SSIS inserts are very slow

    Jack Corbett (11/3/2011)

    I have not read the white paper yet (I do plan to) and yes, it is probably going to get you some spam so use your spam email...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:22 pm

    #1402858

  • RE: SSIS inserts are very slow

    Brandie Tarvin (11/3/2011)

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

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:21 pm

    #1402857

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    Anyone know a good source for on-line SSIS help?

    I'm having a problem with the speed of my main SSIS load package and would love to find...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:18 pm

    #1402852

  • RE: SSIS inserts are very slow

    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 see how...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:17 pm

    #1402851

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

    Best way of speeding that up would...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:15 pm

    #1402849

  • RE: SSIS inserts are very slow

    Brandie Tarvin (11/3/2011)

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

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:13 pm

    #1402845

  • RE: SSIS inserts are very slow

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

    BTW, what...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 11:42 am

    #1402823

  • RE: Are the posted questions getting worse?

    Anyone know a good source for on-line SSIS help?

    I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 11:20 am

    #1402810

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (11/2/2011)

    Stefan Krzywicki (11/2/2011)

    I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 2, 2011 at 12:47 pm

    #1402372

  • RE: Are the posted questions getting worse?

    WayneS (11/2/2011)

    Stefan Krzywicki (11/2/2011)

    Thanks, I know I don't know everything and I might be reading things wrong, it helps to have extra opinions, especially from people who know what they're...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 2, 2011 at 12:38 pm

    #1402365

  • RE: Are the posted questions getting worse?

    GSquared (11/2/2011)

    Stefan Krzywicki (11/2/2011)

    I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 2, 2011 at 12:01 pm

    #1402348

  • RE: Are the posted questions getting worse?

    Thanks, I know I don't know everything and I might be reading things wrong, it helps to have extra opinions, especially from people who know what they're doing.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 2, 2011 at 11:50 am

    #1402336

  • RE: Are the posted questions getting worse?

    I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run any index...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 2, 2011 at 10:32 am

    #1402262

  • RE: Are the posted questions getting worse?

    WayneS (11/1/2011)

    Work just got us all online training from PluralSight (which I've never heard of before). In looking at the SQL Server items, there are some from an author of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2011 at 12:35 pm

    #1401784

Viewing 15 posts - 1,321 through 1,335 (of 2,838 total)