Forum Replies Created

Viewing 15 posts - 38,581 through 38,595 (of 59,072 total)

  • RE: Training for Managers

    jcrawf02 (5/6/2010)

    ask people for topics they'd like to see, there may be things they're working on that they can use help with.

    That's an outstanding idea. Just keep in mind...

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

    May 6, 2010 at 5:19 pm

    #1163714

  • RE: Missing numbers in a series

    Paul White NZ (5/6/2010)

    Jeff Moden (5/6/2010)

    Yep... I remember the "other" triangular join. You made it to be very fast but it still ended up doing the same number 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)

    May 6, 2010 at 4:48 pm

    #1163694

  • RE: Missing numbers in a series

    Paul White NZ (5/6/2010)

    Ok, here's the quick 'n' dirty CLR aggregate:

    Ooooohhhhh mmmmyyyyy ggggooooodddd... someone that actually knows what "//" is for.

    Very well done Mr. White.

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

    May 6, 2010 at 4:45 pm

    #1163693

  • RE: Training for Managers

    AspiringGeek-40457 (5/6/2010)

    "The only thing worse than training everyone and having some of them leave is not training any of them and having them all stay."

    --Zig Ziglar

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

    May 6, 2010 at 12:28 pm

    #1163510

  • RE: SQL Server DBA.... what next?

    sqlwars (5/6/2010)

    Its still DBA and from where I am right now, I dont see fun there.

    I guess, I have done enough of DBA work, i better take a U...

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

    May 6, 2010 at 12:20 pm

    #1163501

  • RE: time function

    I'll have to remember that as one of the things to check on when I install my nice new copy of 2k8 Dev Ed. Thanks, Peter.

    Now that I see...

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

    May 6, 2010 at 6:39 am

    #1163130

  • RE: Calculating the Number of Business Hours Passed Since a Point of Tme

    RTaylor2208 (5/6/2010)

    Thanks I managed to get it all working successfully.

    Also I modified the functions so I could provide 2 dates so I can calculate the time passed between them instead...

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

    May 6, 2010 at 6:36 am

    #1163126

  • RE: inserting Commas

    Heh... actually, it was "cutting edge" at the time with Windows XP Pro and all. 😀

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

    May 6, 2010 at 6:34 am

    #1163120

  • RE: Missing numbers in a series

    @ Paul,

    Yep... I remember the "other" triangular join. You made it to be very fast but it still ended up doing the same number of reads. This one...

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

    May 6, 2010 at 6:32 am

    #1163119

  • RE: Good Enough

    In just about anything I've seen having to do with software, 99% of the people only know how to use 1% of the functionality. A lot of the new...

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

    May 5, 2010 at 11:37 pm

    #1162958

  • RE: Double counting reads in profiler

    Contrary to popular belief, the reads are usually the result of an index or two on the table you're inserting into. There could also be a trigger on 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)

    May 5, 2010 at 11:30 pm

    #1162953

  • RE: time function

    adalberto-339588 (5/5/2010)

    Let me know if it work

    Yes... that would work if there were a date column. The posted problem is quite a bit different... the OP has no date...

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

    May 5, 2010 at 11:28 pm

    #1162951

  • RE: Calculate values for TallyDuration

    Clive,

    First, thanks for posting the test setup... makes it so I can concentrate on your problem and give you a coded answer almost as soon as I see the post.

    See...

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

    May 5, 2010 at 11:25 pm

    #1162950

  • RE: Training for Managers

    Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful tool that's frequently over looked. 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)

    May 5, 2010 at 11:05 pm

    #1162949

  • RE: inserting Commas

    Mark-101232 (5/5/2010)

    Try this

    CREATE FUNCTION dbo.InsertCommas(@s VARCHAR(100))

    RETURNS VARCHAR(100)

    AS

    BEGIN

    SELECT @s=STUFF(@s,Number,0,',')

    FROM master.dbo.spt_values

    WHERE Number BETWEEN 2 AND LEN(@s) AND type='P'

    ORDER BY Number DESC

    RETURN @s

    END

    GO

    DECLARE @s VARCHAR(100)

    SET @s='W'

    SELECT @s,dbo.InsertCommas(@s)

    SET @s='ABWI'

    SELECT @s,dbo.InsertCommas(@s)

    SET @s='AW'

    SELECT @s,dbo.InsertCommas(@s)

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

    May 5, 2010 at 10:35 pm

    #1162941

Viewing 15 posts - 38,581 through 38,595 (of 59,072 total)