Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 3,232 total)

  • RE: SSIS Checksum Transformation

    You've got a couple solutions to look at. One, use the SCD transformation to do the compares for you. You'll still need to configure the updates types in...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 8, 2009 at 10:09 am

    #1050626

  • RE: Checksum function???

    Is there any sort of date column in the source table that could show you which rows have been updated? If you could do something to avoid comparing the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 8, 2009 at 9:53 am

    #1050610

  • RE: local temp table in lookup

    umer.faizal (9/7/2009)

    3. I cannot use variables in the lookup component because SSIS does not have any such option.

    Sure it does. On the advanced tab, where I'm sure you modified...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 8, 2009 at 9:45 am

    #1050604

  • RE: If you weren't a DBA what would you be doing?

    I'd be a full time parent, no questions asked.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 1:25 pm

    #1049045

  • RE: Budget Money to Spend

    gah (9/3/2009)

    just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?

    Our corporate support team plans the DR strategies for our servers. We will be...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 1:21 pm

    #1049040

  • RE: Budget Money to Spend

    Thanks for the info. I've read through them and it sounds very interested. We'll consider this.

    Anyone else??

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 10:33 am

    #1048905

  • RE: Problem: Slowly Changing Dimension - 2 rows with the same PK

    Paul brings up an interesting point in that the business key from the file would not normally be the PK in the table. This whole thing may not happen...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 10:28 am

    #1048899

  • RE: Budget Money to Spend

    I don't want to ask a dumb question Steve, but Fusion SSDs? Can you elaborate a bit on this, have you put this to use anywhere? What kind...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 9:19 am

    #1048832

  • RE: Budget Money to Spend

    Just bumping my thread.....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 3, 2009 at 8:46 am

    #1048801

  • RE: Forcing a Select to use a specific index

    So the moral of the story is that out of 15 years of SQL Server expreience, a query index hint was chosen as the solution 2 times! Just think...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 2:00 pm

    #1048424

  • RE: Forcing a Select to use a specific index

    I, too, have only had to use an index hint one time. At my last company, we had a stored procedure that accepted about 16 parameters and performed a...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 1:28 pm

    #1048402

  • RE: Forcing a Select to use a specific index

    From BOL:

    WITH (

    )

    Specifies that the query optimizer use an optimization or locking strategy with this table and for this statement. For more information, see Table Hint (Transact-SQL).

    In SQL Server...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 1:02 pm

    #1048375

  • RE: SSIS data import reduced to a crawl

    Are you using the Merant driver for Progress? If so, Merant is a third party vendor right? Contact them instead of Progress. By the way, the Progress...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 9:42 am

    #1048255

  • RE: Forcing a Select to use a specific index

    Ha! I was actually quite suprised that no one snuck a post in by the time I finished typing my response.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 9:36 am

    #1048251

  • RE: Forcing a Select to use a specific index

    1. Yes. The query optimizer will analyze the query, the table/index structure, and the data distribution and determine the most optimal query plan for that query. So you...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 2, 2009 at 9:28 am

    #1048242

Viewing 15 posts - 1,006 through 1,020 (of 3,232 total)