Forum Replies Created

Viewing 15 posts - 26,086 through 26,100 (of 59,102 total)

  • RE: Unexplained Performance Observation

    BrerSQL (8/26/2013)

    Sequential GUIDs definitely would make sense.

    I'm not so sure that's true. If the computer is rebooted, the start of a new sequence might not be > the largest...

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

    August 27, 2013 at 1:23 am

    #1645032

  • RE: SSIS Question Help

    Glad some things never change.

    I edited my post without realizing that you had responded. Isn't there some "For Each" loop that can get and loop through files in a...

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

    August 27, 2013 at 1:17 am

    #1645030

  • RE: SSIS Question Help

    Koen Verbeeck (8/26/2013)

    rocky_498 (8/26/2013)

    Thanks, that was I was thinking....

    I am thinking how about If I get Recent file name from folder?

    Is anyone can please guide me how i can recent...

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

    August 27, 2013 at 1:12 am

    #1645027

  • RE: Can you please help me??

    techmarimuthu (8/26/2013)

    I have some doubts in using of loops in sql server 2005

    can you please anyone help me?

    Thanks in advance

    Probably but you need to ask the actual question you have....

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

    August 27, 2013 at 12:59 am

    #1645024

  • RE: Where Statement

    lindavol (8/26/2013)

    THANK YOU - this works when I am in design and go to run

    But does not work when I double click on the report and apply the parameters. ...

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

    August 27, 2013 at 12:54 am

    #1645021

  • RE: Do we have possibility to update system tables in SQL..

    I don't believe you can anymore. Part of the reason is because a lot of people really messed up their systems by updating system tables. What is 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)

    August 27, 2013 at 12:47 am

    #1645019

  • RE: LTRIM,RTRIM

    kk1173 (4/2/2013)

    Its not that simple.

    The team that loads the data will need to clean the data, but they do not want to do it and we do not have...

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

    August 27, 2013 at 12:28 am

    #1645015

  • RE: Log LDF file

    Backups and restores are a wonderful thing but, if the data is THAT important and mistakes in the form of modifications and deletions are made THAT often, then it's time...

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

    August 25, 2013 at 9:04 pm

    #1644782

  • RE: Log LDF file

    Deg-235673 (8/25/2013)

    Yes, I've a solution for your problem, and I can say it's possible take a rollback rows straight from the log, you can get in touch with me.

    sincerely Dondeg

    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)

    August 25, 2013 at 8:59 pm

    #1644781

  • RE: String to date conversion issue

    simflex-897410 (8/25/2013)

    However, the issue we have now is that when we try to update same date value, it stores a different formatted value like:

    And now you understand why storing...

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

    August 25, 2013 at 8:51 pm

    #1644780

  • RE: Are the posted questions getting worse?

    GilaMonster (8/25/2013)

    Jeff Moden (8/25/2013)

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    What's yours?

    I have a few, but I need fodder for the PASS presentation (that's due today) 😀

    Not necessarily my favorites but here'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)

    August 25, 2013 at 8:46 pm

    #1644779

  • RE: NULL issue

    Erland Sommarskog (8/25/2013)

    Jeff Moden (8/25/2013)

    I like to have options no matter how infrequently I may use them.

    Having spoken we with a few SQL Server Developers, I know that SET options...

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

    August 25, 2013 at 8:13 pm

    #1644776

  • RE: Are the posted questions getting worse?

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    What's yours?

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

    August 25, 2013 at 2:54 pm

    #1644754

  • RE: NULL issue

    Understood but, as you said, users can learn. I view it as another option scheduled for removal, possibly only for the convenience of MS, and I like to have...

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

    August 25, 2013 at 2:40 pm

    #1644749

  • RE: using Sqlpsx functions on a production sql box

    Indianrock (8/24/2013)

    Saving to files with timestamp in the name. The request was to keep error log entries ( other than backup/logon messages ) for a year. 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)

    August 25, 2013 at 2:23 pm

    #1644747

Viewing 15 posts - 26,086 through 26,100 (of 59,102 total)