Forum Replies Created

Viewing 15 posts - 29,956 through 29,970 (of 59,101 total)

  • RE: RegEx for DBAs

    I used to work in the "E Discovery" business where millions of documents where compared and screened for similarities, key words, and other patterns. We had tools such as...

    --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 17, 2012 at 4:20 am

    #1488887

  • RE: Query Cost 27%

    Evil Kraig F (5/16/2012)

    Jeff Moden (5/15/2012)

    Gosh... if all that were true, it wouldn't be worth having things like calendar tables.

    Alright, I'll bite into that one... there's nothing in there 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)

    May 16, 2012 at 8:00 pm

    #1488760

  • RE: parse string

    You know me... I don't go into these things blind. I always have test data. Helps me keep my alligator mouth from overloading my humming bird hinny. 😛

    --=====...

    --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 16, 2012 at 7:21 pm

    #1488757

  • RE: parse string

    RBarryYoung (5/16/2012)

    Jeff:

    Do you have a test-set that I can use to test against?

    Yep... I'll post it soon. Gotta clean it up a bit.

    --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 16, 2012 at 7:02 pm

    #1488755

  • RE: Capacity Planning - Mostly disk usage- Tool

    sqldba_newbie (5/16/2012)

    Jeff Moden (5/15/2012)

    sqldba_newbie (5/14/2012)

    I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy 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)

    May 16, 2012 at 10:23 am

    #1488543

  • RE: parse string

    capn.hector (5/16/2012)

    Sean Lange (5/16/2012)

    OMG :w00t:

    Jeff Moden posted a loop.

    There is only darkness now, there is no sunshine. The mayans were correct.

    Parden me, I must send out an email...

    --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 16, 2012 at 10:18 am

    #1488540

  • RE: Is Software Engineering Dead?

    Lisa Slater Nicholls (5/15/2012)

    The work they do now is significantly better than the work they did when they started.

    ...{snip}...

    We don't approach them the same way as we used 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)

    May 16, 2012 at 6:57 am

    #1488351

  • RE: Converting first letter of every word to uppercase

    BWAAA-HAAA!!! Thanks for having a good sense of humor, Dwain! You've made my day! 🙂

    Shifting gears back to the subject at hand... there's a While Loop solution 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)

    May 15, 2012 at 11:15 pm

    #1488171

  • RE: parse string

    Sean Lange (5/15/2012)

    I would suggest that the looping concept above is not going to be very good for performance.

    Actually, that's not true for these types of problems. About 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 15, 2012 at 11:09 pm

    #1488170

  • RE: ad hoc queries

    SQLKnowItAll (5/15/2012)

    Its kind of like asking what's the difference between a salad and a fruit. A salad can be made of fruit or vegetables, and a fruit can be in...

    --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 15, 2012 at 10:59 pm

    #1488168

  • RE: parse string

    pnpsql (5/15/2012)

    thanks to all , now i do it my way can you please help to shorten this code

    declare@strvarchar(20)= '[p]a]a]s]s][p'

    declare@posint

    select@pos= charindex('[', @str)

    while@pos<> 0

    begin

    select@str = stuff(@str, @pos +...

    --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 15, 2012 at 10:27 pm

    #1488163

  • RE: Converting first letter of every word to uppercase

    dwain.c (5/15/2012)

    Jeff Moden (5/15/2012)

    dwain.c (5/15/2012)

    Jeff Moden (5/15/2012)

    dwain.c (5/14/2012)

    Forgive me oh experts for I have sinned. I have not compared performance against other suggestions. 🙂

    Since you used a recursive CTE...

    --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 15, 2012 at 8:27 pm

    #1488144

  • RE: Query Cost 27%

    Evil Kraig F (5/15/2012)

    Alone (5/15/2012)

    How to change non clustered index scan to non clustered index seek?The concerned tables already have non clustered index configured.

    Typically? You don't. 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)

    May 15, 2012 at 8:02 pm

    #1488135

  • RE: Capacity Planning - Mostly disk usage- Tool

    sqldba_newbie (5/14/2012)

    I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool...

    --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 15, 2012 at 7:57 pm

    #1488131

  • RE: How to load a temp table with the result set of a sproc

    Geoff A (5/15/2012)

    absolutely. and i know when you say "couple of sandwiches", you mean "a few beers". I'm there, buddy. 😛

    Well, it does have about the same amount of yeast...

    --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 15, 2012 at 7:53 pm

    #1488130

Viewing 15 posts - 29,956 through 29,970 (of 59,101 total)