Forum Replies Created

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

  • Reply To: SSIS and Date Ranges

    Well, this is a big one (for this data set), at ~200-450K rows.  So, maybe not _tiny_, but certainly not huge, compared to a lot of others out there.

  • Reply To: SSIS and Date Ranges

    Lookup to determine new / existing, conditional split for changed / unchanged, and and OLE DB Command for the actual update, like all the other data flows in the ETL....

  • Reply To: SSIS and Date Ranges

    Trying to narrow the problem down, but a rough outline of the overall process is:

    1. Load from staging table
    2. Populate a couple of calculated columns
    3. Add a bunch of reference...
  • Reply To: SSIS and Date Ranges

    Another update:

    With some additional tweaks and improvements, the version that's using a staging table is running in about 10 hours, and the version that's using a script is running in...

  • Reply To: SSIS and Date Ranges

    This update is primarily for anyone who comes across this in the future, with a similar question.

    For my case, Unpivot was slower than the script component, because I was able...

  • Reply To: SSIS and Date Ranges

    Yeah, when I have to work with the long, ugly queries, I usually pop them in to either gVim or SSMS, but it's an extra step, and doesn't change the...

  • Reply To: SSIS and Date Ranges

    Let's just say I'm using this as a learning experience and want to try different ways, even if I end up going back to staging tables in the end.

    Also, seriously,...

  • Reply To: SSIS and Date Ranges

    @alphatangowhiskey -- Ah!  I missed that one, hiding down at the bottom of the Other Transforms list!  Thanks; I'll see if I can get what I need from...

  • Reply To: Datadog

    I've used it extensively in the past, but we're not currently doing a lot with it, though we may scale back up.  The customer support reps were always extremely helpful,...

  • RE: Who should have Sysadmin rights?

    Agree with minimum necessary privileges, but also, in order to avoid accidentally modifying prod instead of dev / test, I find it's useful to use Register Server in SSMS and...

  • RE: Parameter Fun

    Chris Wooding - Tuesday, March 5, 2019 6:18 AM

    Steve Jones - SSC Editor - Monday, March 4,...

  • RE: Parameter Fun

    patrickmcginnis59 10839 - Monday, March 4, 2019 4:13 PM

    I like using the convention of calling the -[char], --[keyword] etc switches or options, after...

  • RE: Parameter Fun

    I should unpack that a little more. The fundamental Unix conventions were established in the 1960s and 1970s, when computers were far more limited in CPU, memory, and network bandwidth. ...

  • RE: Parameter Fun

    Steve Jones - SSC Editor - Monday, March 4, 2019 10:24 AM

    man command is something I used to use often. I just...

  • RE: Schema Security

    We mostly use schemas for organization, but we do have some per-schema permissions set. This is partly because the DB started in MySQL, and was only recently migrated to SQL...

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