Forum Replies Created

Viewing 15 posts - 25,501 through 25,515 (of 59,099 total)

  • RE: Combining everything to present the whole picture

    herladygeekedness (10/31/2013)

    Facts will always be on your side.

    Were I you, I would make darned sure of what the processes currently do, and how they are done, in order that you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:43 pm

    #1663305

  • RE: Move file from one Directory to other

    Dhananjay-440114 (10/31/2013)

    The Code in my thread works fine... By the way its a long back story..:)

    We have the time. Fire away. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:25 pm

    #1663303

  • RE: Move file from one Directory to other

    Isle.Of.Mull (9/19/2008)

    Unfortunately, my web hosting vendor does not allow xp_cmdshell or sp_OACreate. 🙁

    I was looking at these options to move a file as well as means to export table...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:24 pm

    #1663302

  • RE: Move file from one Directory to other

    Kenneth Wilhelmsson (2/27/2008)

    Security concerns around xp_cmdshell is a valid point...

    I've found that most of the security concerns about xp_CmdShell are mostly based on emotion rather than anything practical. Turning...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:20 pm

    #1663300

  • RE: Move file from one Directory to other

    Dhananjay-440114 (2/21/2008)

    I don't want to use xp_cmdshell due to security reasons.

    Heh... here we go again. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:15 pm

    #1663299

  • RE: Becoming an MVP

    GilaMonster (10/31/2013)

    krowley (10/31/2013)

    Sigh , I hate the whole job hunting process and was sort of hoping a short cut at least existed. Not that I would have been able to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 5:07 pm

    #1663297

  • RE: Export table and import file - fastest way

    learnwithvideotutorials (10/19/2013)

    BCP would be fastest option. To import to a table you can use OPENROWSET with ot without BULK option.

    Or just BULK INSERT for the import.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 4:52 pm

    #1663296

  • RE: udf very slow?

    Eric Mamet (10/31/2013)

    I know but I was hoping it would be fast...

    Just talked to my customer and I'll try using CLR!

    Yipee!!! 😀

    Heh... hate to throw a wet blanket...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 4:43 pm

    #1663294

  • RE: udf very slow?

    Sean Pearce (10/31/2013)

    It is much faster to apply a table function.

    CREATE TABLE Test1 (ID INT);

    GO

    INSERT INTO Test1

    SELECT TOP 1000000 ROW_NUMBER() OVER (ORDER BY a.object_id)

    FROM sys.all_columns a

    CROSS JOIN sys.all_columns b

    GO

    CREATE FUNCTION...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 4:38 pm

    #1663293

  • RE: Fill up position numbers

    David Burrows (10/31/2013)

    My solution (bet Jeff picks holes in it :Whistling:)

    Create a format file containing...

    No. You're absolutely on the same track I was going to go with except I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 4:05 pm

    #1663287

  • RE: Fill up position numbers

    Steve Goram (10/31/2013)

    column/max. length

    Pos-Nr 5

    item description 50

    color 20

    price 5

    thanks for your help.

    Where'd the "Pos-Nr" come from? I don't see it in your test data. Based on this post,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 4:02 pm

    #1663286

  • RE: Running Count

    AronB (10/31/2013)

    Jeff Moden (10/30/2013)

    AronB (10/30/2013)

    Thank you all for your solutions. It's greatly appreciated.

    The question now would be, do you understand how and why they work?

    Yes, I do, but would be...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 3:50 pm

    #1663284

  • RE: Improving SSIS Update Performance

    RonKyle (10/31/2013)

    Great article. Lots to think about. Any thought to testing deleting the rows to be updated so that everything is then an insert. I'm not necessarily...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 9:11 am

    #1663118

  • RE: Improving SSIS Update Performance

    Oh... I almost forgot. Check the desination table for triggers. If it has one of those bloody "generic audit triggers" (GAT) on it, then that can cause huge...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 9:08 am

    #1663116

  • RE: Improving SSIS Update Performance

    Gosh... still more than 2 minutes using the "fastest" option. How many rows were in the source?

    Heh... and I have to admit this is the first time I've ever...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 31, 2013 at 9:01 am

    #1663111

Viewing 15 posts - 25,501 through 25,515 (of 59,099 total)