Forum Replies Created

Viewing 15 posts - 37,951 through 37,965 (of 59,072 total)

  • RE: Records per hour within a time span

    Eugene Elutin (6/18/2010)

    Nice problem.

    Here is my first attempt:

    declare @periodStart datetime

    declare @periodEnd datetime

    -- they must be inside of the same day!!!!

    set @periodStart = '20100601'

    set @periodEnd = '2010-06-10 23:59:59.000'

    declare @givendate datetime

    set...

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

    June 18, 2010 at 4:52 pm

    #1182381

  • RE: Simple query for the Months of a year

    Dan.Humphries (6/18/2010)

    just to throw my two since in I think that if you are doing a full blown table with dates then this is a better option this is particularly...

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

    June 18, 2010 at 2:11 pm

    #1182342

  • RE: Cursors Be Gone!

    TheSQLGuru (6/18/2010)

    Myself and a number of other MVPs have been hitting Microsoft up to get them to make cursors perform much better on the platform, which would be a benefit...

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

    June 18, 2010 at 1:02 pm

    #1182323

  • RE: Formatting and Readability

    Agreed... both formatting and appropriate commenting are essential ingredients to good code.

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

    June 18, 2010 at 6:51 am

    #1182091

  • RE: Create date range with only one date using previous record's END DATE

    Considering that the data you used for that example is quite a bit different than your original example, I'm not surprised my code failed. 😉 You even mixed...

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

    June 17, 2010 at 5:08 am

    #1181465

  • RE: Calculate Return Using Quirky Update

    Sorry... I've been sick and haven't touched a computer in almost 2 days.

    Lemme ask... does your latest couple of posts mean that you're all set or do you still need...

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

    June 17, 2010 at 4:53 am

    #1181457

  • RE: Best practice for test environment?

    Grant Fritchey (6/14/2010)

    Jeff Moden (6/11/2010)

    If you have a decent SAN, learn how to use the SAN "clone" or "snapshot" feature. We used it to "replace" a Tera-Byte copy of...

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

    June 17, 2010 at 4:51 am

    #1181454

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (6/14/2010)

    Gianluca Sartori (6/14/2010)

    Well done on the "Mentor" thread, Gail.

    Hope he stops.

    It seemed to me that the argument was coming from one side today. It appeared that Jeff bailed...

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

    June 15, 2010 at 9:47 am

    #1180536

  • RE: Calculate Return Using Quirky Update

    I just saw this, Vijay. It's almost 4 in the morning and I have to be at work in a couple of hours. I can't get to this...

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

    June 15, 2010 at 1:54 am

    #1180237

  • RE: Mentor

    I guess I'll have to agree to disagree with you on the challenge thing, Dave. And, no... just to be sure, I'm not picking on Jacob's good forum per...

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

    June 15, 2010 at 1:38 am

    #1180234

  • RE: Mentor

    Hello again, John,

    Here’s an example of what I meant in the previous post. Hopefully, you'll understand why it's good to have more than one mentor.

    Using the original problem description,...

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

    June 15, 2010 at 12:44 am

    #1180214

  • RE: Mentor

    john-902052 (6/14/2010)

    All,

    I wasn't trying to start a fight. I was just wondering if there was a good hearted individual that would be willing to help me learn to think...

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

    June 14, 2010 at 9:35 pm

    #1180180

  • RE: Mentor

    scott.pletcher (6/14/2010)

    Hmmm... perhaps I should start a new challenge... I'll write some code and we'll have people figure out how the requirements should have been stated

    Sigh. Consistently all 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)

    June 14, 2010 at 8:49 pm

    #1180179

  • RE: Mentor

    scott.pletcher (6/14/2010)

    An interesting quote in a (semi-)recent article from Joe Celko:

    Here is a characteristic for good SQL programming: do as much work as you can in ONE statement, so the...

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

    June 14, 2010 at 8:05 pm

    #1180173

  • RE: Inserting / Selecting / Truncating - Question.

    SQLSeTTeR (6/14/2010)

    Its inserting from the same table its selecting from, but it's truncating data coming from the same column. What am I missing?

    DECLARE @To int, @From int, @LogonID...

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

    June 14, 2010 at 7:48 pm

    #1180169

Viewing 15 posts - 37,951 through 37,965 (of 59,072 total)