Forum Replies Created

Viewing 15 posts - 48,466 through 48,480 (of 59,102 total)

  • RE: Cursor

    Heh... understood... I think they call that "agile" programming and I hate it. 🙂

    You said in your previous post that ID's 1-6 were singleton's... looking at the data you provided,...

    --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)

    September 3, 2008 at 5:16 pm

    #866883

  • RE: Debugger For SQL

    TheSQLGuru (9/3/2008)

    Jeff Moden (9/2/2008)

    Carl Federl (9/2/2008)

    Jeff & GSquared:

    Did either of you get a chance to perform any additional analysis ?

    No, I sure haven't... my apologies. Have a new job...

    --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)

    September 3, 2008 at 5:12 pm

    #866882

  • RE: Problem with the text data column, variable

    Chris Morris (9/3/2008)

    However you can't add characters to a text value

    You're right, Chris... my bad. I lost track of the basis of this thread. Thanks for the feedback.

    --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)

    September 3, 2008 at 5:05 pm

    #866880

  • RE: How to improve insert performance

    Ray Mond (9/3/2008)

    You could also check the growth rate that's set for your data and log files. If it's too small (e.g. in 10 MB increments), the insert will...

    --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)

    September 3, 2008 at 5:02 pm

    #866877

  • RE: Understanding Index defragmentation

    GilaMonster (9/3/2008)

    gcg_wilkinson (9/2/2008)

    I've found that even if u defrag an index and the physical disk is fragmented, then the index will remain fragmented.

    It shouldn't contribute to the logical fragmentation. That's...

    --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)

    September 3, 2008 at 4:58 pm

    #866874

  • RE: For Each Loop [Exec SQL Task, Send Mail]

    olafdedig (9/3/2008)

    SOLUTION:

    Hello, Here is the solution I found to my problem:

    For doing a task like sending html mail (built using a SQL script and a Script Task) the for...

    --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)

    September 3, 2008 at 4:56 pm

    #866873

  • RE: For Each Loop [Exec SQL Task, Send Mail]

    Ummm... I'm not very smart about SSIS because I don't use it... I always use something else like BCP, etc.

    That, not withstanding, I follow the logic of the flow you've...

    --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)

    September 2, 2008 at 8:33 pm

    #866317

  • RE: Cursor

    Heh... you keep adding scope to the problem, Simon. Not a problem but it would be nice to know the whole problem at once. For example, where did...

    --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)

    September 2, 2008 at 8:28 pm

    #866316

  • RE: Debugger For SQL

    Carl Federl (9/2/2008)

    Jeff & GSquared:

    Did either of you get a chance to perform any additional analysis ?

    No, I sure haven't... my apologies. Have a new job with 1:10+ commute...

    --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)

    September 2, 2008 at 7:58 pm

    #866312

  • RE: How to improve insert performance

    James Horsley (9/2/2008)

    It may be better to have a different index as the clustered index - obviously this might hurt performance elsewhere so it would require testing and a lot...

    --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)

    September 2, 2008 at 7:54 pm

    #866310

  • RE: database and transaction logs on same drive?

    Yeaup... but if you loose the disk where the log file is, you're still going to miss data regardless of backups.

    --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)

    September 2, 2008 at 7:52 pm

    #866309

  • RE: Delete File Without xp_cmdshell

    Peso (9/2/2008)

    A CLR procedure maybe?

    Heh... better be limited to only the directory being worked on or you might as well open up xp_CmdShell.

    --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)

    September 2, 2008 at 7:44 pm

    #866307

  • RE: Problem with the text data column, variable

    I'm pretty sure you don't need PATINDEX if you prewrap the string to be split in delimiters... please see the section titled "One Final "Split" Trick with the Tally...

    --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)

    September 2, 2008 at 7:41 pm

    #866306

  • RE: swap data between 3 fields?

    The 96 columns you're talking about each identify a region id for a person... and, I imagine that you have some nulls on each row. To normalize the 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)

    September 2, 2008 at 7:31 pm

    #866303

  • RE: Table Update

    Thanks for the feedback...

    --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)

    September 2, 2008 at 7:27 pm

    #866302

Viewing 15 posts - 48,466 through 48,480 (of 59,102 total)