Forum Replies Created

Viewing 15 posts - 1 through 15 (of 64 total)

  • RE: Index on table with 70+ million rows

    Jeff Moden (8/23/2016)

    Rowan-283474 (8/23/2016)

    Sergiy (8/23/2016)

    Rowan-283474 (8/23/2016)

    Rowan-283474 (8/23/2016)

    Sergiy (8/23/2016)

    Sergiy (8/22/2016)

    Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?

    Can...

    August 24, 2016 at 12:37 am

    #1897101

  • RE: Index on table with 70+ million rows

    Sergiy (8/23/2016)

    Ok, there is another option.

    Count records grouped by, say, a week.

    And reload only the rows which belong to weeks where the counts are different.

    If a record was updated you'll...

    August 23, 2016 at 4:19 pm

    #1897071

  • RE: Index on table with 70+ million rows

    Sergiy (8/23/2016)

    Rowan-283474 (8/23/2016)

    Rowan-283474 (8/23/2016)

    Sergiy (8/23/2016)

    Sergiy (8/22/2016)

    Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?

    Can you answer this?

    Yes...

    August 23, 2016 at 3:50 pm

    #1897062

  • RE: Index on table with 70+ million rows

    Jeff Moden (8/23/2016)

    Rowan-283474 (8/23/2016)

    Jeff Moden (8/22/2016)

    Rowan-283474 (8/22/2016)

    ...the source is line of business type transactional records and there is no way to link up rows from my table back to the...

    August 23, 2016 at 9:43 am

    #1896954

  • RE: Index on table with 70+ million rows

    Rowan-283474 (8/23/2016)

    Sergiy (8/23/2016)

    Sergiy (8/22/2016)

    Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?

    Can you answer this?

    Yes unfortunately I...

    August 23, 2016 at 7:37 am

    #1896903

  • RE: Index on table with 70+ million rows

    Sergiy (8/23/2016)

    Sergiy (8/22/2016)

    Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?

    Can you answer this?

    Yes unfortunately I have...

    August 23, 2016 at 7:35 am

    #1896901

  • RE: Index on table with 70+ million rows

    Jeff Moden (8/22/2016)

    Rowan-283474 (8/22/2016)

    ...the source is line of business type transactional records and there is no way to link up rows from my table back to the source table thus...

    August 23, 2016 at 7:26 am

    #1896898

  • RE: Index on table with 70+ million rows

    Eric M Russell (8/22/2016)

    Rowan-283474 (8/22/2016)

    Eric M Russell (8/22/2016)

    Rowan-283474 (8/22/2016)

    Unfortunately delta operations aren't possible as the source is line of business type transactional records and there is no way to link...

    August 22, 2016 at 1:09 pm

    #1896750

  • RE: Index on table with 70+ million rows

    Eric M Russell (8/22/2016)

    Rowan-283474 (8/22/2016)

    Unfortunately delta operations aren't possible as the source is line of business type transactional records and there is no way to link up rows from my...

    August 22, 2016 at 12:40 pm

    #1896735

  • RE: Index on table with 70+ million rows

    Unfortunately delta operations aren't possible as the source is line of business type transactional records and there is no way to link up rows from my table back to the...

    August 22, 2016 at 10:16 am

    #1896702

  • RE: Index on table with 70+ million rows

    Cool thanks John

    That is pretty much the line of thinking I had as well, I just needed another point of view.

    August 18, 2016 at 5:02 am

    #1896107

  • RE: Index on table with 70+ million rows

    Well the table is part of an ETL process, so it gets truncated and re-populated with approx 70 mil rows.

    Before I populate the table I disable all indexes and then...

    August 18, 2016 at 4:36 am

    #1896102

  • RE: Filegroup Archiving

    Yes I have seen it mentioned before with regards to taking a filegroup offline.

    How is this done though?

    August 5, 2015 at 4:36 am

    #1817427

  • RE: Filegroup Archiving

    When you say complex, what do you mean exactly 🙂

    August 5, 2015 at 3:17 am

    #1817410

  • RE: Script task fails, makes Job fail

    Thank you

    I will look into this!

    August 30, 2010 at 4:52 am

    #1213657

Viewing 15 posts - 1 through 15 (of 64 total)