Forum Replies Created

Viewing 15 posts - 38,896 through 38,910 (of 59,098 total)

  • RE: Continuing Education

    dma-669038 (4/16/2010)

    Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best are those that are...

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

    April 16, 2010 at 3:06 pm

    #1153162

  • RE: Map IP Address to a Geographical Location

    webrunner (4/16/2010)

    Jeff Moden (7/25/2009)

    Heh... sorry Peter... Thought you were trying to flatten the trajectory of a pork chop for some reason. 😀 I'm a bit touchy because I'm trying...

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

    April 16, 2010 at 12:51 pm

    #1153077

  • RE: Test - ignore this

    Lynn Pettis (4/15/2010)

    Tom Brown (4/15/2010)

    It doesn't work for me - it has worked in the past - but not in the past few weeks

    IE just goes away for ages...

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

    April 16, 2010 at 7:30 am

    #1152824

  • RE: Talking Back

    Brandie Tarvin (4/16/2010)

    Me? I try to keep my personal life out of my blog. I don't want the entire universe to know that I'm a Timelord from...

    Heh... same here......

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

    April 16, 2010 at 7:25 am

    #1152813

  • RE: Talking Back

    Brandie Tarvin (4/16/2010)[hrWhereas writing an article takes effort, thinking about the theme, doublechecking your thought processes, ...

    BWAA-HAA! Apparently, some folks don't know the difference. 😀

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

    April 16, 2010 at 7:22 am

    #1152810

  • RE: Continuing Education

    dma-669038 (4/15/2010)

    but I'd like a juicy messed up situation to learn from. How do you create one? Would love to hear more from others in this regard.

    Heh... just read 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)

    April 16, 2010 at 7:17 am

    #1152807

  • RE: Select a string when data in the string varies

    Here's the output from the first bit of code above...

    Date Time ParameterName ParameterValue

    ---------- -------- ------------- -----------------------------------------------------------------------

    2010-04-08 00:00:02 Cmd ...

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

    April 15, 2010 at 9:25 pm

    #1152564

  • RE: Select a string when data in the string varies

    Here's what I was talking about to simplify the split at the "=" sign...

    --=================================================================================================

    -- Test table setup. This is NOT a part of 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)

    April 15, 2010 at 9:15 pm

    #1152561

  • RE: How to find unused Stored Procedures in SQL Server 2005/2008

    First up I start with the SQL Server Profiler with a slightly changed version of the "SP_Counts" template. After my modifications [font="Arial Black"]I have based the template on the "SP:Starting"...

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

    April 15, 2010 at 8:08 pm

    #1152558

  • RE: Talking Back

    It's interesting... SQL Server Central has taken it on the chin a couple of times about the low quality and/or bad information which sometimes appears in its articles because 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)

    April 15, 2010 at 7:40 pm

    #1152555

  • RE: Talking Back

    awoodhouse (4/15/2010)

    From what i understand of the companies i've worked at, you don't broadcast or discuss company confidential information ever. So in that regard, blogging is already covered. It's already...

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

    April 15, 2010 at 7:20 pm

    #1152554

  • RE: which software?

    If you're looking for a "perfect" copy of production to put into development and have a decent SAN, then you could use a "SAN Snapshot" (has nothing to do with...

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

    April 15, 2010 at 7:04 pm

    #1152551

  • RE: Test - ignore this

    You CAN post code... look at the "IFCode Shortcuts" when you create a new post or reply to one. Surround your code with one of the shortcut "pairs" 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)

    April 15, 2010 at 7:08 am

    #1152076

  • RE: Select a string when data in the string varies

    WayneS (4/14/2010)

    Jeff Moden (4/14/2010)

    Wayne... just split on the "=" sign using SUBSTRING and CHARINDEX. It doesn't need to be Pivoted using a CrossTab to be used very effectively.

    I utilized...

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

    April 15, 2010 at 6:25 am

    #1152049

  • RE: Continuing Education

    skjoldtc (4/14/2010)

    I think some standards should exist. I don't necessarily want government involved, but, at some level to help identify what a person can do at a basic level.

    I've known...

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

    April 14, 2010 at 3:07 pm

    #1151767

Viewing 15 posts - 38,896 through 38,910 (of 59,098 total)