Forum Replies Created

Viewing 15 posts - 646 through 660 (of 844 total)

  • RE: Production Subsets

    We have a small set of data on our DEV environment. But we only use this area to basically test that the code does not fail. Then to...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Titles Matter

    I would guess I've had more than 6 different job titles over the 20+ years. And it just changed again from Lead Programmer Analyst to Lead Application Developer. ...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: What was that field name?

    Didn't know about the Alt + F1, thanks for the comments. Currently I find the IntelliSense to more annoying than helpful, so I turned it off.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Back from Sabbatical

    Welcome back Steve. Can't wait to hear what you did on your sabbatical. That is a nice perk I wish we all had.:-)

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    Evil Kraig F (7/16/2014)


    When he did his test, did he use the same source data? When he did, did he remove the new data (or changes) from the target...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    Evil Kraig F (7/15/2014)


    Your DBAs have to understand that the INSERT is Cost of Business.

    Currently we don't have one. The one that suggested this quit.

    Thanks Craig and...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    I should have mentioned that it's not just this example I mentioned, we have a lot more tables where we are doing the same steps. Extract data from a...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Is It Time To Clear Out Those Quirky Functions?

    I would like to see the TRIM available. And why not change ISNULL to work the same way COALESCE does. ISNULL just seems to be more descriptive of...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Never give up

    I guess I always look at a problem as always having a solution. I may not have the answer but I believe it is out there. Just last...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: SQL Battleship

    I've noticed a pattern in the shots the computer takes, at least on my server. Does that mean I played it too much?:-) Shots start out with E05...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Using a Stored Procedure to truncate tables?

    Koen Verbeeck (6/30/2014)


    Seems like a bit of overkill for such a simple statement.

    Maybe they just don't want SQL code inside the SSIS packages.

    While I agree with not having SQL in...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: does choosing indexed table col for where clause helps and does order of table matters?

    Eric M Russell (6/25/2014)


    below86 (6/25/2014)


    Eric M Russell (6/25/2014)


    below86 (6/25/2014)


    Eric M Russell (6/25/2014)


    Fortunately the construction of the execution plan (for example which table is used as the outer or inner input...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: does choosing indexed table col for where clause helps and does order of table matters?

    Eric M Russell (6/25/2014)


    below86 (6/25/2014)


    Eric M Russell (6/25/2014)


    Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested loop...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: does choosing indexed table col for where clause helps and does order of table matters?

    Sean Lange (6/25/2014)


    below86 (6/25/2014)


    But from a 'Best Practice' standpoint, I always try, when possible, to have my inner joins listed first.

    How or why is this "best practice"? I create joins...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: does choosing indexed table col for where clause helps and does order of table matters?

    Eric M Russell (6/25/2014)


    Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested loop or hash join) isn't...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

Viewing 15 posts - 646 through 660 (of 844 total)