Forum Replies Created

Viewing 15 posts - 24,106 through 24,120 (of 59,099 total)

  • RE: SSIS Load Balancing??

    sqlbuddy123 (3/20/2014)

    Jeff Moden (3/20/2014)

    sqlbuddy123 (3/19/2014)

    MyDoggieJessie (3/18/2014)

    No I don't think you can tell SSIS how to do this - but if I understand you correctly (you want to throttle the SSIS...

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

    March 20, 2014 at 10:51 am

    #1698792

  • RE: Data Manipulation Question

    @Dwain,

    Thanks for the awesome compliments. :blush: I just aim to help. I sometimes miss but I'm always aiming. 🙂

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

    March 20, 2014 at 5:55 am

    #1698645

  • RE: Data Manipulation Question

    SQLSeTTeR (3/19/2014)

    Never played with CROSS Tab. Do you have an example I can play around with?

    I looked into books online but not sure if I'm looking at the right thing...

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

    March 20, 2014 at 5:43 am

    #1698641

  • RE: SSIS Load Balancing??

    sqlbuddy123 (3/19/2014)

    MyDoggieJessie (3/18/2014)

    No I don't think you can tell SSIS how to do this - but if I understand you correctly (you want to throttle the SSIS to do its...

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

    March 20, 2014 at 5:29 am

    #1698635

  • RE: 3rd Party Backup Utility Hangs

    homebrew01 (3/20/2014)

    You could contact the backup software company. Perhaps they have "retry" settings that will help if there is contention or network problems.

    That's why I like homegrown solutions. It...

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

    March 20, 2014 at 5:22 am

    #1698633

  • RE: Data Manipulation Question

    SQLSeTTeR (3/19/2014)

    I redesigned the structure. The PIVOT function helped me out. Thanks all for your input!

    Just so you know, PIVOT is typically slower than CROSS TABs.

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

    March 19, 2014 at 7:09 pm

    #1698560

  • RE: SSIS Load Balancing??

    Dumai (3/18/2014)

    They range in the amount of time they take from seconds to a couple of days.

    Gosh... a "couple of days"??? :blink: There's something [font="Arial Black"]really [/font]wrong there....

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

    March 19, 2014 at 6:21 pm

    #1698553

  • RE: TEMPDB on RAM

    jeffrey yao (3/19/2014)

    Jeff Moden (3/19/2014)

    jeffrey yao (3/19/2014)

    "putting lipstick on a pig", haha.. LOL, very well said Kurt.

    Indeed, throwing more resources (hardware or better technology, like upgrading from standard 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)

    March 19, 2014 at 4:49 pm

    #1698547

  • RE: 3rd Party Backup Utility Hangs

    Welsh Corgi (3/19/2014)

    I have an Network Administrator running a 3rd Party Backup Utility on an instance of SQL Server.

    On one instance the 3rd party Backups are hanging. Everything is fine...

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

    March 19, 2014 at 4:46 pm

    #1698546

  • RE: Fast inserting\reading\deleting of millions of records

    darren_ferris (3/19/2014)

    This causes more of an issue with the underlying stored procedures and the maintenance of them as we have to use lots of dynamic SQL that becomes difficult 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)

    March 19, 2014 at 2:06 pm

    #1698516

  • RE: Data Manipulation Question

    masoudk1990 (3/18/2014)

    I prefer to write this kind of queries with this technique:

    Select

    (SELECT DOB FROM [Table] WHERE DOB IS NOT NULL) AS DOB,

    (SELECT LNAME FROM [Table] WHERE LNAME IS...

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

    March 19, 2014 at 2:02 pm

    #1698515

  • RE: TEMPDB on RAM

    jeffrey yao (3/19/2014)

    "putting lipstick on a pig", haha.. LOL, very well said Kurt.

    Indeed, throwing more resources (hardware or better technology, like upgrading from standard to enterprise edition) is usually...

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

    March 19, 2014 at 1:43 pm

    #1698512

  • RE: TEMPDB on RAM

    jeffrey yao (3/19/2014)

    MS actually does have "TempDB in RAM" today. It defaults to that and only spills to disk if it gets too large for a given session. ...

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

    March 19, 2014 at 1:39 pm

    #1698508

  • RE: Is it possible to use a parameter for csv values

    Ed Wagner (3/19/2014)

    Another approach is to convert the list into a table and then run your query against the table. Here's an example using @strParams as your passed parameter...

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

    March 19, 2014 at 9:11 am

    #1698415

  • RE: TEMPDB on RAM

    jeffrey yao (3/17/2014)

    I actually initially did not want to continue in this thread because I do not see there are any fundamental differences between everyone's views (ie. making tempdb quicker...

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

    March 18, 2014 at 2:46 pm

    #1698196

Viewing 15 posts - 24,106 through 24,120 (of 59,099 total)